1 Reply Latest reply: Jun 9, 2011 11:20 AM by Mike Reese RSS

    Need to exclude formatting from pivot subtotals

    Mike Reese

      I am trying to format cells in a pivot table, but I want to ignore the subtotals. 

      Ex, the three salmon columns should have no formatting like the top row.

      The formula shown works for the top row, but not the pivoted dimensions.

       

      Thanks!

        • Need to exclude formatting from pivot subtotals
          Mike Reese

          Here it is:

           

          Basically, dimensionality takes care of the top totals row (rows dimension).  ColumnNo’s 0,-1, and -2 take care of pivoted column totals.  I'm conditionally showing Start Date, with a different format.

          if([SP Completed Date]>0 and dimensionality()<>0 and match(ColumnNo(),0,-1,-2)=0,rgb(255,255,215),
                
          if(dimensionality()<>0 and match(ColumnNo(),0,-1,-2)=0 and [SP Start Date]>0, rgb(255,206,206))
                 )