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?
I gave that a try Colin, and hoped for a miracle ....it didn't happen!
I ticked 'indent mode' and then the chart turned into a hideous mess. I can see what it was trying to do, but wasn't what I needed for this.
I've not used that funtionality before, but now I know what it does.
I added the new expression, as you suggested, and the chart listed all products (regardless of the 40% margin restriction), along with the totals at the bottom of each product group.
I guess the way I've manipulated the expressions to filter out the lower performing products is affecting the calculation process of the total rows.
I now know that the partial sums are working, they are just not compatible with my expressions.
Thanks for your help.
You need to check "Show Partial Sums" for each Dimension. Each level that you check shows the aggregate subtotal for that dimension. Right now you have partial sums checked for "Prod Grp No" only. Since that is the highest level, at the moment, the pivot chart will only display a grand total of everything. If you want subtotals for each "Prod Grp No", you need to select the dimension that is one level below, which is "Prod Grp Desc".
I understand how the Presentation tab is confusing. If you notice, there is a border around the top section labeled "Dimensions and Expressions." Everything within that border applies only to the currently selected dimension or expression. Everything in the below section, which is unlabeled, applies to the entire chart.
I hope this helps.
I am facing the same problem as yours. Is your problem solved? To resolve this problem I changed my expression using sum(Aggr(Expression),Dim1,Dim2,Dim3.....)) and I achieved my Output, But the chart becomes very heavy as loading time increased a lot because I am using 15 Dimensions and 44 Expressions. Do you have any solution for such kind of problem? Please suggest me any solution to come out of it.