Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using a pivot table with 'show partial sums' on the Brand/Generic column (column 2):
However, I really need the Price Term values sub-totaled within the 'Combined' section like this:
Any suggestions on how to accomplish this? I'm guessing 'show partial sums' isn't going to be sufficient.
Did you try enabling Partial Sums for Brand/Gen column and Price Term Column.
Yes, the top screen cap is the result of having both of them enabled. Is my only solution going to be two sheet objects? I sure hope I'm wrong. It's not the most end-user friendly...