0 Replies Latest reply: Sep 25, 2016 6:19 AM by Chris Weldon RSS

    Alternate dimensions

    Chris Weldon

      i have a stacked bar chart calculating the percentages of a measure by a dimension. So for example, how much of a payment is cost, expenses, profit and commission etc. For each Sales branch.  I am using set analysis to calculate the values, so I am currently using the TOTAL<Branch> syntax to calculate the % and it works fine.

       

      But I really want to make the dimension a set of alternatives so you can see the premium split by branch, carrier, product type etc. How do I change TOTAL<Branch> to reflect the selected dimension?

       

      is this possible?

       

      Many thanks

       

      chris