Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone
I am trying to achieve the following:
I need to list the number of order that hasn't movement in the past X days.
I solved this as you can see in the example (doing a set analysis).
But what I really want to do, is make the restriction in the dimension (with a calculate one).
I dont want to do it with a set analysis, because I need to repeat the same set analysis in every column (in the real model are a lot more).
I dont know if a calculated dimension could be defined with a Concant or a aggr function.
If the in the dimension is used the "if" statement, the result is not the correct.
Any suggestion?
Thanks
try this.
=
if ( '$(NofDays)'>(Aggr(Max(MovementDay),Order)), Order,Null() )
try this.
=
if ( '$(NofDays)'>(Aggr(Max(MovementDay),Order)), Order,Null() )
In the example application works perfect, I will check in the real application with another condition (status of the order) and I will let you know if I need more help.
Very thanks