Hi Geniuses,
I want to create one chart which will have the value something like below
| Month | Client | Sony | Samsung |
|---|
| Jan | | 5000 | 6000 |
| Feb | | 5020 | 6090 |
| Mar | | 6000 | 7000 |
| Apr | | 6030 | 7050 |
now how the 5000 will come in Jan for sony --> it will be the count of records from all the previous years till Jan
now how the 5020 will come in Feb for sony --> it will be the count of records from all the previous years till Jan + count of records of feb
when I am using the set analysis like this in a text box count( distinct{$<YEAR = {">1978<2016"}>} VENDOR_SITE_ID ) and selecting the customer it is giving me the correct count of records of the customer
but when I am putting the same set analysis in the chart above it is not dividing the count as per the clients.
can you please look into this
Thanks in advance
S
