I am trying to create a straight table that will show me a bunch of calculations where each row represents a different time period (as seen in the attached file), so the only difference is the Date dimension.
For this, I have created the following inline table:
Periods_Menu: NoConcatenate LOAD * INLINE[ %Period_Desc, %Period_Date_Diff, %Period_Sort_Val Yesterday, -1, 1 Last 7 Days, -7, 2 Last 30 Days, -30, 3 Last 90 Days, -90, 4 ];
I have a field in my calendar called 'Date Diff' which represents the difference in days from today, so the date of a week ago will have the value of -7, the date of yesterday will have the value of -1, today will have the value of 0 etc.
What I am trying to do is set the 'Date Diff' value to be greater than the value that is shown under the %Period_Date_Diff field in my inline table, but without success.
I tried using the only() function but that happens to work only if one period is selected. I also tried using the 'Pick' and 'Match' functions, but still without any success.
I see what you are saying, the problem is I have quite a lot expressions to manage, so I figured it'll be easier to handle it using this set analysis option. But, according to your reply, I guess this isn't possible.