2 Replies Latest reply on Jul 26, 2018 12:09 AM by Zhouyi Zhang

    Cumulative sum till the filtered year

    Anika NIgam

      My data is from Year 2011.I want to keep a filter on year, for eg - if from filter 2013 is selected , the pie should show the sales from 2011 till 2013. I tried it doing by running sum , but as soon as we filter it on year ..running sum doesn't work.

      Also tried lookup function  - lookup(attr(year),0) but its showing filter in a different way, I want it to be like 'Single Value list', don't want a slider.

       

      Thanks in Advance.