5 Replies Latest reply: Jul 5, 2013 7:19 AM by samskip samskip RSS

    how to show as a % of in a table with multiple dimensions

      Dear All


      I want to show the volumes as a percentage of the total volumes.

      this works fine with below formula, where the dimension unit is ignored.


      Sum(Volume)/ Sum({$< Unit= >}TOTAL Volume)))


      but when I add the dimension Month on top it does not work anymore, as I want a 100% total for each month.

      see attachment of what I am trying to achieve.


      please to hear from you.