4 Replies Latest reply on Jan 13, 2014 3:44 AM by Vania Turner

    Custom Define Row Total

    Vania Turner

      Hi all,

       

      I have 3 columns in a table as follows:

       

      Column A: Year A Revenue

      Column B: Year B Revenue

      Column C: Year B's Percentages on Contracts awarded

       

      Column C refers to percentages of contracts awarded, e.g. 25% of project A, 10% of project C, etc.

       

      When adding all subtotals (Analysis, Totals, Add All SubTotals) , there is no point in "sub totaling" column C as this is meaningless. I end up with with garbage values such as 220%, etc.

       

      I need a kind of filter that would enable me to filter on subtotals, if subtotal <= 100%.

       

      Alternatively exclude Column C from the Subtotal operations or create a kind of custom subtotal calculation. None of which I've been able to do.

       

      Any ideas ??

       

      thanks,

      Vania.