Hi there I know how to display subtotals in the totals column, but for a given subtotal, I want to display it in another column, repeated next to each row that makes up that subtotal.
Thanks!
Hi there I know how to display subtotals in the totals column, but for a given subtotal, I want to display it in another column, repeated next to each row that makes up that subtotal.
Thanks!
Since you have O365, why not move on from old, dead, non-updating Pivot Tables and use dynamic arrays instead.
Delete expected results and use:
Formula:Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Of course, if you want to select binders and pens somewhere.. from a drop-down... that's easily added in.
For a pivot table (most definitely not dead or old ), you can use the data model and add a measure like:
=CALCULATE(SUM([Units]),ALLEXCEPT(tblSalesData,tblSalesData[Item]))
See attached version of your workbook.
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks