6 Replies Latest reply: Oct 10, 2018 2:19 PM by Rob Wunderlich RSS

    How to calculate dimension total in pivot table ?

    Claudia Lettten

      Hi all

       

      Here is are my columns and measures in a Pivot table

       

      Retailer  :             Apple                   Verizon                       Sprint 

                                  50                           50                                50         

       

      ( Should show subtracted total from collapsed dimension below)

       

      Sales:        + online    +store             + online    +store             + online   + store

                               20         70                  20        70                   20         70

       

       

      Instead  it keeps showing 70.

       

        How do I write expression to show subtracted total  instead?