I am trying to show partial sums on my pivot table, I normally have no problems, so can't understand what why today I'm having difficulties!
I have selected the 'partial sum' on the relevant expressions in the presentation tab, but no total rows appear.
I noticed in the expressions tab the Totals Mode box is completely greyed out ....for all the expressions (see attached screen shot).
Can anyone point in the direction of enabling the totals?
As I stated in the initial query, I have already selected the 'partial sum' indicators in the presentation tab. I just wondered if the totals mode being greyed out contributed to the lack of totals showing on the chart. I guess not.
My next step is to rule out an 'odd' expression.
This is my pivot table:
I want to show totals (partial sums) under each 'Prod Grp No'.
The expressions are as follows (in order):
As you can tell from the expressions, I only want to show products with a margin over 40%, any under 40% are replaced with null.
This is my presentation tab settings:
I can't upload the file as I don't have authority to share this company data on a public forum.
Can anyone see any glaring reason why the partial sums aren't showing? Am I asking too much from the pivot table?
Thanks again for your time and help.
Tick the Partial Sums option on each dimension you want to be summed.
Ticking partial sums on Prod Grp No will just add an overall total.
Tick the partial sums option for ProductDesc as well.