5 Replies Latest reply on Apr 11, 2014 5:43 AM by Prashant Sharma

    Sub total in a calculated field

    Laura Binette

      Hello everyone,


      I have a graph which diplays the sales per city and per geographical zone. I would like to have another graph which displays percentages per city inside a zone, ie. for one zone, the total will be 100%.


      My current expression is :


      SUM([Sales]) / TOTAL (SUM ([Sales]))


      I don't know how to specify in the second part that I want the total per zone instead of the general total.


      Thank you for your help