Stacked up monthly comparison where each bar consist of previous month's data

[serenemak]

Hi please help me with this.. i would like to see a stacked up monthly comparison. 

For example, below's data is from Dec 2023 to Jan 2023

Country	User Count (Distinct)	%
Singapore	10	9%
Malaysia	15	13%
Indonesia	22	19%
India	45	39%
Thailand	23	20%
Total	115	100%

below is Dec 2023 to feb 2023

Country	User Count (Distinct)	%
Singapore	15	12%
Malaysia	10	8%
Indonesia	27	21%
India	40	33%
Thailand	30	26%
Total	122	100%

what i want to have as outcome in bar chart e.g. singapore

Jan : 9%

Feb : 12%

Please let me know if this is possible. Thanks!

[RossEdwards]

Sounds like you want a bar chart where the Axis is the city and the legend is the month?

[serenemak]

Hi, maybe i will have the city as the filter? but in the chart, i would want to see axis is the month, while values will be the %

[RossEdwards · Accepted solution]

Yes, if you only want to show 1 country at a time you could just not put it in the Axis but use a filter instead.

I just saw this in my head when reading your description.