-
1. Re: Filter combined with Set: Calculation of "ALL" - Values
Simon RuncJun 15, 2018 2:36 AM (in response to Anton Scharton)
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?
-
2. Re: Filter combined with Set: Calculation of "ALL" - Values
Mavis LiuJun 15, 2018 2:36 AM (in response to Anton Scharton)
1 of 1 people found this helpfulHi 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