Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please suggest how to use rank function in my variable :
vError:
sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))
Can you please explain the problem? I mean what exactly do you want to rank? Do you want to rank the sum of Absolute Numbers aggregated by multiple dimensions (mentioned in the code above)?
As I described above, I have an variable name vError which I am using in my expression but its not working according to the slider which I used.
For that I need to use the Rank function to work my slider.
the [Absolute Error] is not calculating according to the selection of slider.
Can you please share a sample application? It will be easier that way.
As I described above, I have an variable name vError which I am using in my expression but its not working according to the slider which I used.
For that I need to use the Rank function to work my slider.
the [Absolute Error] is not calculating according to the selection of slider.