7 Replies Latest reply: Mar 25, 2016 10:32 AM by Annick Whitfield RSS

    Line Chart - Months without sales - Select a month



      In reference to a previous post (Line Chart - Show Months without Sales), I was given the helpful advice to use this formula in order to display all months even without sales:

      Sum({$<Country -= {'US'}>}Price) +Sum({1} 0)


      I implemented it and it works very well (i.e. months without sales are shown):



      I am now facing another issue:

      If I select March, I get the following graph:




      Ideally, I would like to show the months that have been selected (if any), but still show all months if no selection has been made. Would you know if there is a way to achieve this?

      Many thanks

      Kind Regards