3 Replies Latest reply: Feb 13, 2017 2:19 PM by Sunny Talwar RSS

    Decrement sum of sales per year

    ignacio blanco

      Hi!

      I have a bar chart, with sum sales per year.

      My problem is that i lose clients as the years increase. i want to make  an acomulate sum with the clients.

      For example

       

      i have 3 clients, and Sum(Sales) are 120 millons in 2015.

      In 2016 i lose 1 client and the Sum(Sales) are 100millions.

       

      The information in my table is:

       

      Client

      ClientYearSales

      Client 1

      201520
      Client 2201650
      Client 3201750

       

       

      Something like that

       

      Capture.PNG

       

      Thanks for all