Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have two measures as a stacked chart
measure 1 is blue colour (example) and shows as 75 = sum(sales)
measure 2 is red colour (example) and shows as 25 = sum(targets)
so together they show as 75 + 25 = 100
75 blue, 25 red.
How do I show it in %
75% blue, 25% red
Thanks
Hi @D19PAL
You must change the definition of your measures by:
measure 1= sum(sales)/(sum(sales)+sum(targets))
measure 2 = sum(targets)/(sum(sales)+sum(targets))
Hi @D19PAL
You must change the definition of your measures by:
measure 1= sum(sales)/(sum(sales)+sum(targets))
measure 2 = sum(targets)/(sum(sales)+sum(targets))
Can you help me with my other question about 2 measures in stacked bar summing them up.