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.