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

    Conditional subtotalling in pivot tables

    Jarno Loubser



      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.