4 Replies Latest reply: May 17, 2016 5:48 AM by David Pertegal RSS

    ignore selection with set expressions

    David Pertegal

      Hi all,

       

      I'm trying to ignore selections in the field [Booking Month] and at the same time forcing to get the higher value for the field [Booking Week] with this formula and it's not working:


      sum({<[Booking Month],[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)


      If I use the next formula I ignore the selection made in [Booking Month] field:


      sum({<[Booking Month]} >}Pax)


      and if I use the next formula I will get the result for the higher value for [Booking Week] field:


      sum({<[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

       

      Do you know how can I combine both? maybe is because both dimensions are related?


      thanks,


      David