14 Replies Latest reply on Feb 22, 2019 8:22 AM by Shinichiro Murakami

    Select year and previous year based on same filter

    Amit Darak

      Hi ,

       

      I want to select value based on a filter.

       

      As seen in the dashboard attached, when I select a year in filter I need to see data month wise and its grand total which is already done.

      Also when I have selected a filter I need to see consolidated values only for the previous year which will be in another sheet. and then I will combine 2 sheets as already done in dashboard.

       

      For eg if select year 2018 in filter, I need to see 2018 data month wise and only consolidated values of 2017. Similarly if I select 2019 in filter,  I need to see 2019 data month wise and only consolidated values of 2018 and so on.

       

      I have created another sheet for previous year. But don't know how to achieve what I want to.

       

      Any help!!