Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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%
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%
Hi Oleg,
Thank you very much for your reply. Your suggestion totally works! I really appreciate your time!
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?
This solved the problem I've been working on for the last two hours! Thank you!