1 Reply Latest reply: May 14, 2018 11:13 AM by Sunny Talwar RSS

    Sum % of a variable

    Mario Vella

      Can anyone kindly help me?

      I have two dimensions (Region, city) and a measure (sale). Here the values

       

      RegionCitySales
      LombardyMilan127.391,33
      LombardyMilan119.348,40
      LazioRoma   18.511,46
      TuscanyFlorence   87.786,00
      TuscanySiena   55.312,22
      TuscanyFlorence200.691,51
      LombardyPavia   68.262,00

      How can I manage the set analysis in order to have the sales in Milan as a percentage of the sales in Lombardy ?

      The result is (127.391,33+119.348,40)/(127.391,33+119.348,40+68.262,00).... but I don't know what to do in  a set analysis.

      Thanks for any help

      Mario