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