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