Stacked Bar Chart - 100%

[#1]

I do not see an option for a 100% Stacked Bar Chart (as is available in PowerPoint). Does anyone have a workaround for this?

Thanks.

[Oleg_Troyansky · Accepted solution]

The workaround is to calculate percentages in your expression. For example:

Dimensions:

Country

City

Expression:

sum(Sales) / sum( TOTAL <Country> Sales)

This way, the sales for each City will be presented as a % from the sales for each Country. At the Country level, the result is always 100%

[#3]

Hi Oleg,

Thank you very much for your reply. Your suggestion totally works! I really appreciate your time!

[#4]

Oleg - that does indeed work. But, you knew this was coming, what if I want to have the count of each of the bars in each of the segments that make up each bar - and not the percentage total.

For instance - if I display each country on the x-axis and each bar is split by city. The measure looks at the number of people visiting, how can I display the actual number of people visiting and not using the % of the total for each city/country combo?

[#5]

This solved the problem I've been working on for the last two hours! Thank you!