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

       

      Laura