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,




      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


      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.