2 Replies Latest reply on Mar 9, 2018 7:22 AM by Ahmed Abdullah

    How do I add "Total" for calculated field?

    Ahmed Abdullah

      Dear All,

       

      greetings,

       

      I would like to add "Total" for calculated fields [YTD] and [YTD %] as per attached screenshot.

      I know how to do this in normal field (Analysis -> Totals -> Show totals) but this doesn't shows the total of calculated fields?

       

      I tried to create separated calculated field named "Custom GT YTD" as below

      if FIRST()==0
      THEN WINDOW_SUM([YTD])
      END
      

       

      it works fine in terms of value but i do not know how to add it at the lest row of the table just like normal Total and Grand total field?

       

      Please advise.