6 Replies Latest reply: Aug 2, 2016 9:03 AM by Ruben Marin RSS

    getselectedcount - with time bracket

    Joanna Seldon

      hi

       

      I am using the following expression on a measure on a pivot table.

       

      sum({$<[EventDate.CalendarMain.Date]={">=$(=Date(Today()-6))<=$(=Max(EventDate))"}>}[Sales])

       

      however I need to be able to select an event date from a filter pane, and the pivot table will thus show - 6 days from the selected event date.

       

      I have tried to use

       

      getselectedcount within a sort expression on EventDate , I cannot get this to work.

       

      If( GetSelectedCount(EventDate), Max(FinancialYear), (EventDate)-6) )

       

      please help