Hi all,
i would appreciate if someone could point me into the right direction with how to achieve the below:
i have a simple market share measure in a bar chart:
=sum([QTY]) / sum(TOTAL {<supplier>} [QTY])
which gives me a market share based on qty of purchased items in a certain time bracket.
I would like to add another bar right next to it with a measure describing min target % - this comes from another table which looks like that:
supplier / category / ms% min / ms% max
supplier1 / category a / 60% / 100%
supplier1 / category b / 11% / 20%
supplier2 / category a / 11% / 20%
what would be the best way to achieve this?
