14 Replies Latest reply: May 25, 2012 1:25 AM by Jarno Loubser RSS

    Conditional subtotalling in pivot tables

    Jarno Loubser

      Hi,

       

      I am trying to only show the subtotal row when more than one row is being totalled – without losing the grant total.

      In the example below only Stock Fin Group = MFB should be subtotalled,not all the others because they don’t have different colour combinations.

       

       

       

      Capture.JPG