2 Replies Latest reply: Oct 8, 2011 9:41 AM by Michael Solomovich RSS

    Set Analysis in Date Dimension

      Is it possible to put a set modifier in a date dimension?


      i.e. date({$<Step={4}>} Date, 'MM-DD-YY')


      An order can go through many steps, but i want all of the order's information to report on the date that step 4 occurs.


      My problem occurs when I'm doing a stacked graph comparing the data of each step, so data that occurs on step 5 reports on the date of step 5, not step 4.


      Please help!