7 Replies Latest reply: Jun 28, 2018 9:29 AM by Wanyun Yang RSS

    Bar Chart - accumulation

    Wanyun Yang

      My data has fields Year (2016,2017,2018) and ID. I want to create a bar chart with dimension: Year, measure: COUNT(ID). The thing is, I want the accumulated result. For example, if I select Year=2016, it will show me count of ID in 2016; if I select Year=2017, it will show me count of ID in 2016 & 2017, and so on.

       

      How should I create the function?

       

      Thanks for help!