Skip to main content

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

7 answers
  1. Sep 2, 2020, 9:30 AM

    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?

0/9000