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

    Line Chart - Months without sales - Select a month

    Annick Whitfield

      Hello,

       

      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