Bar Chart with Full accumulation does not work...

[danialier]

Hello,

I have a bar chart (stacked view) showing the revenue month over month for two customers. That's ok.

However, I tried to build the same chart with the accumulated revenue month over month and it does not work 'cause there are some months were the revenue has been generated by one customer and the other way round. Then the accumulation does not work...

I attached the QV doc and xls for your reference

Please help

Best regards,

dani

[Gysbert_Wassenaar]

See attached qvw.

[danialier]

Hi Gysbert,

Taking your qvw, the accumulated revenue in the month of Apr'14 is not working....

It should be 23 (7 customer x in March + 7 customer y in March + 9 customer x in March)

However you have 16 (7 customer x in March + 9 customer x in March), so taking your qvw you're missing customer y accumulated in April'14

thanks,

dani

[Gysbert_Wassenaar · Accepted solution]

Apparently I forgot to save the qvw before attaching it. I've replaced it with the correct file now.