Stacked Bar: filtered countries plus all the rest

[rkoldanov]

Hi all!

I have a quick question here. Tracking sales of a product, I have the Revenue and the Country Name. Eight countries are grouped separately as per business policy. What I want to show on the visualisation - a bar chart with the total revenue, stacked - with the total revenue from these separately grouped countries, the total revenue of the rest of the countries in the world, so the combined stacked bar would be our total revenue for the period.

The countries are specified with a filter within the visualisation

Hope I explained it clearly… kind of.

Thanks!