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

Customizing Partial sums

welsa_chy

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!!!:)