hi Anton,

So one way is to take advantage of the way FIXED LoDs work...in that they are computed before any "regular" filters are applied.

So I created this LoD, which gets the profit for 'Deudction' and applies it to every row (so both the Sweden/Germany rows) so when they are filtered we still have access to this value.

[Profit (Deudction)]

{FIXED [Month = Month_Paramter]: SUM(IIF([Country]='Deudction',[Profit],NULL))}

I the attached I've brought them in as 2 fields, but you could combine them if you only want a single value (being the aggregated SUM of the Profit for country (or countries) and the 'Deudction'. You can repeat the same logic for Cost.

Hope that makes sense?

Hi Anton,

You could create a parameter for country, populate it as below:

Then create this calculation:

and add this to the filters shelf and set it to true. Remove the country filter and country set filters. The use this parameter as your new list:

Please see attached.

Thanks,

Mavis