Mekko Chart - Percentages

[#1]

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

[#2 · Accepted solution]

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?

[#3]

Thanks Pari Pari, just what I needed.