3 Replies Latest reply: Jun 19, 2017 8:27 PM by Sunny Talwar RSS

    Prior Month Total Set Expression Issue

    Marco Barroso

      I have the following set expression. If I use the {1} as the set identifier I get the previous mt total, however the issue I am having is that ANY other dim selections will be disregarded, which is not desirable.

       

      PriorMonth =COUNT( DISTINCT

                          {1<

                              [DateType]={'Refs'},

                              [CanonicalDate.Calendar.YearMonth]={'$(vPreviousCalendarMonth)'}

                          >} RefId )

       

      I've tried to change the set identifier to {$} and also changed the date dimension attribute to ignore, but didn't work. I get zeros for the prior month.

       

      =COUNT( DISTINCT

                          {$<

                              [DateType]={'Refs'},

                              [CanonicalDate.Calendar.YearMonth]=,

                              [CanonicalDate.Calendar.YearMonth]={'$(vPreviousCalendarMonth)'}

                          >} RefId )

       

      Is there a way to ignore the YearMonth and still use any other selections ?