4 Replies Latest reply on Sep 20, 2017 10:14 PM by Srikanth N

    How to calculate the Column Grand totals except for one row.

    Srikanth N

      Hi There,

       

      I want to show the column grand totals for every column except for one row's values.

       

       

      I want the sum of calculation 1 except for Office supplies. (It's fine if I have to exclude office supplies). sum of Calculation 1 for Furniture depends on the Office supplies Value. So if I exclude Office supplies it in turn changes the

      Value for Furniture.  Could you please please help me with achieving this. Thanks in advance. 

       

      Many Thanks,

       

      Srikanth N