2 Replies Latest reply: Apr 3, 2015 5:53 AM by Simona Arnone RSS

    Subtotal of pivot table depending on row number

      Hi All,

       

      is it possible to have conditional subtotals based on number of rows?

      In the example below the state "California" has two rows, so it's correct to show the subtotal (Total=1704210,80), instead for the state "Colorado" I don't want to show subtotal (Total=448301,50).

      Probl.PNG

       

       

      Could you help me?

       

      Thanks & Regards,

      Simona Arnone