3 Replies Latest reply on Oct 17, 2013 11:41 PM by . Indumon

    Customize grand total

    Yogi Birajdar


      I am working on waterfall graph and having some trouble with grand total.

      I used MIN() and MAX() to customize the total as suggested here.

      Basically, I have to compute grand total as grand total=(last table column value- grand total). I am unable to get the last table column value in grand total calculation. I tried with WINDOW_SUM(SUM([REVENUE]),LAST(),0) but its returning sum of all revenue.

      Any help will be appreciated.