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