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.