I am using the below for opening calc:
IF {INCLUDE :MIN([PERIOD_ID])} = [PERIOD_ID] then [MEASURE] END
and this for closing calc:
IF {INCLUDE :MAX([PERIOD_ID])} = [PERIOD_ID] then [MEASURE] END
However I want to assign a bool at the lowest level, every category depending on what period I select, whether or not the opening measure is different to the closing measure?
So for one period ID they would be the same, but the more periods I filter for that bool would change.
For example if you had a list of stores, I want to filter for all the stores whose space has/has not changed across the period selected
Please help
Unfortunately [Store] is not on rows/cols shelf;
I tried this, and it seems to work if you add period filter to context
IIF({fixed [Store]:COUNTD([Space])}>1, 'Changed', 'Not Changed')
Any concerns with this? Things I may be missing?