Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a mekko chart and I would like to show each bar/column in the chart as totalling 100% so that the first bar shows the values 75% and 25% respectively for the underlying counts 15 and 5 (currently they show 1500% and 500% - see qvw attached)
Thanks in advance for any help,
Rutger
its not that simple:)
but if you are determinated to do this you can do a little trick
=sum(Ticket_Count)/sum(total <Country> Ticket_Count)
as an expression
is that what you want?
its not that simple:)
but if you are determinated to do this you can do a little trick
=sum(Ticket_Count)/sum(total <Country> Ticket_Count)
as an expression
is that what you want?
Thanks Pari Pari, just what I needed.