3 Replies Latest reply on May 7, 2018 6:43 AM by Zhouyi Zhang

    Yearly Sales and latest 2 years variance in single sheet

    keerthana kumar

      yearly sales & variance.JPG

       

      I have to build a dashboard like above Sate wise Sales for year (2015 , 2016) with drill down option Year-->Quarter-->Month.

      as well as Variance sum(2016 sales) - sum(2015 sales) ,variance %  at the end in single sheet .

       

      My current issues is slider in both the sheets ,doesn't make an effective dashboard.

      when drilled down to month level it should show only sales . Variance and variance % is only at year level.

       

      Is there any way to achieve this