4 Replies Latest reply on Jul 11, 2016 12:04 AM by Somok Sarkar

    Year to Month Calculation

    Somok Sarkar

      Hello Everyone,

       

      I have a requirement which seems to be straight forward however somehow I am not able to do that.

       

      We have a graph that represents Order Date (Year) vs Sales as a bar chart. Lets take an eg where I have 2010- 2019 as years and their corresponding sales figure as a bar chart. Now I want to keep a filter as well where the user can select any one year.

       

      Then I want the graph to represent the underlying monthly trend. I shouldn't make it as a dashboard action so it should be done in one sheet only. So incase if the user select the year as 2015 from the filter the graph should change to Months(of 2015) vs sales.

       

      Many Thanks,

      Somok