7 Replies Latest reply: Aug 19, 2015 9:37 AM by Jonathan Dienst RSS

    Display Message when no data is selected (YTD)

    Philipp Schöck

      Hi all,


      I have a table with an YTD (year to date) expression. This works greate.

      But I want to show a message if no date is slected, because in this case the table is empty.


      At the moment i use this for calculating my ytd:


      sum({<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} AmountofOrder)


      If no date is selected it looks like this:



      In this Case I want to display the Message "Please select a Year and Month"




      How could I do that?


      Many Thanks for your efforts.