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

    getselectedcount - with time bracket

    Joanna Seldon



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




      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