5 Replies Latest reply on May 20, 2016 12:19 PM by Ivan Young

    Compare Dimension Member to Grand Total

    Gregg Hirshberg

      Unfortunately, my company won't allow me to share data at this time.

      5.19.PNG

      In the graph above, the yellow line represents the total for the Enterprise. What I want to be able to do is, is filter by Organization and compare any given Organization against the Enterprise total. There's around 20 Organizations. Is anyone aware of the calculation or formatting that I'd need to use, to make this happen?

       

      The trend line shows the average total over the time period, so I could probably get by if I could allow the user the ability to insert a trend line for the Organization of their choice.

       

      Thanks in advance for your help. And if you have any questions about the layout of the data, please ask away.