5 Replies Latest reply: Sep 28, 2016 4:20 AM by junlong chen RSS

    Pivot subtotal by dimensions

    Sarah Nguyen

      How do I get subtotals of sub-dimensions in a pivot table? I have used the 'Show Totals' on all the dimensions, but I need sub-totals by category. Excel attached.

       

      Dimensions:

      1. Charges_region
      2. Charges_Location_Name
      3. If(match(Charges_CPT_Rollup,'New Clinical Patients','Established Clinical Patients','Excisions','Mohs Surgery'),Charges_CPT_Rollup)

       

      Expressions:

      • sum({$<Charges_CPT_KeyStatReport={'Y'},Charges_Department={'Clinical','Surgery','Phototherapy','*Unmapped*'}>}quantity)

       

       

      Thank you.