I've tried to do a chart to show to growth of my company and I'm not able to do all I want. Here it is.
The problem is when i filter some year. I want to show the number of employee that started the year and ended year. 2018 started with 1190 and ended with 1703 employees, but in the chart show like this:
How can I fix that?
Here is the set statement that I'm using:
RangeSum(Above(count(distinct[ASSOCIATE ID-ID]), 0, RowNo()))- RangeSum(Above(count(distinct [Id Global Desligado]), 0, RowNo()))