Set analysis problem in chart

[Anonymous]

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

[sushil353]

Hi,

Can you share a sample data set. ? Ideally it should work if you have added a customer dimension.

[sujeetsingh]

follow this

Full Accumulation in Straight Table, more than one Dimension

Show totals in Straight Table Chart

Accumulated against sorting data in straight table