11-03-2023 10:38 AM
Hello,
Is it possible on the same quickview to cross both Time and Scenario Filter?
For example I need the cross of :
Time "2022" with scenario "ESTIMATE"
Time "2023" with scenario "Planning_2023M10"
But I have some datas on 2023 cross ESTIMATE I don't want to see.
Attached what I have and what I need.
Thank you!
Solved! Go to Solution.
11-03-2023 11:38 AM - edited 11-03-2023 11:40 AM
Hi Vincent: I would recommend using an override (we call them 'mashups' internally). You'll remove the Scenario from your column filter and append it to each specific time period. For example:
T#2022:S#ESTIMATE,
T#2023:S#Planning_2023M10
If you want to make it clear that overrides are applied, use the :Name() function at the end with MemberFilter variables. Example:
T#2022:S#ESTIMATE:Name(|MFTime| |MFScenario|),
T#2023:S#Planning_2023M10:Name(|MFTimeDesc| |MFScenarioDesc|)
11-03-2023 11:38 AM - edited 11-03-2023 11:40 AM
Hi Vincent: I would recommend using an override (we call them 'mashups' internally). You'll remove the Scenario from your column filter and append it to each specific time period. For example:
T#2022:S#ESTIMATE,
T#2023:S#Planning_2023M10
If you want to make it clear that overrides are applied, use the :Name() function at the end with MemberFilter variables. Example:
T#2022:S#ESTIMATE:Name(|MFTime| |MFScenario|),
T#2023:S#Planning_2023M10:Name(|MFTimeDesc| |MFScenarioDesc|)
11-03-2023 11:53 AM
Thanks so much!
The best tip of the year for me and a lot of my colleagues!
Just the second part takes time to retrieve but it is not a mandatory need.