This content has been marked as final. Show 3 replies
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!!!:)