3 Replies Latest reply: Nov 26, 2013 8:20 AM by ljackson RSS

Customizing Partial sums


Hi Guys,


is there a way to customize partial sums, and make them have the value of the previous dimension?


for example if i have category then subcategory then products in hierarchy. i want a partial sum on subcategory

but i dont want the label to be just "Total" i want it like "Total Subcategory XXX" where "XXX" is the value of the previous dimension that is Subcategory


i found other threads on that and i am not sure i found that they have replied..


please guide me to other threads if my question is a duplicate... thanks.


Its on a pivot table!!!:)