2 Replies Latest reply: Jun 20, 2015 12:50 AM by umar khan RSS

    How can we calculate the Sum of Rows in a Pivot Table ?

    umar khan

      Hi All,

       

      I have an expression that goes like this

       

      if(Allow = 'Y', SUM({$<DirAmount={'-1'}, Contract = {'1'}>} POAmount + ConAmount),

        if(Allow <> 'Y' and Contract = '1',

        SUM({$< DirAmount={'-1'}, Enddate = {'>=$(vEndDate)'}>} POAmount + ConAmount), 0))

       

      I am getting the correct values when displaying this in a straight table with checking the Sum of rows checkbox or when exporting to excel.

       

      How can I display the sum of row values in a pivot table ? Or even display it in a straight table by checking the Expressions Total option.

       

      Thanks,

      Umar