Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I need to add the filter Year=2019 to the following variable in Set analysis?
$(Variable1)
What I am trying to do is something like this, but don´t know how to write it...
$({<Year={"2019"}>}Variable1)
Thanks in advance!!
If you want your variable always on latest year, create variable
vYear = max(Year)
then use set analysis like
=Sum({<Year={$(vYear)}>}Sales)
Hi
try like this
Sum({<Year={"2019"}>},$(Variable1))
Replace aggregation function according to your requirement
hope this helps
Thanks
Thanks for your help @Kashyap_R , you seem to understand what I was looking for!!
But I´ve get an error, when I use your formula it says ')' expected.
Hi
Try this
Sum({<Year={'2019'}>}$(variable))
just syntax error
Hope this works and solve your problem
Thanks
Based on your expression I can see that your variables have Count functions. You may need to use Aggr function to work this properly
=Sum({<Year={2019}>} aggr($(vNet Sales)-$(instaladas),Dimension1,Dimension2))
Where, Dimension1 & Dimension2 are the Dimensions you are having in the chart where you are using this expression.