Im trying to display cumulative value based on date for multiple companies in a line chart. Basically the idea is to display a cumulative line for each selected company, ie. If I select 2 companies, it should draw a 2 lines, one for each company.
Heres what ive have done:
I have a table that has 3 columns.
|Company||Transaction date||Transaktio_ distributed|
What Im doing, is displaying a linechart with Company and Transaction date as dimensions, and the following expression as a measure: rangesum( above( total sum(Transaktio_distributed),0,1000)).
If I select only Company x, the data is correctly displayed. If I select both companies, the numbers get all messed up.
What formula do I need to use for Transaction distributed for this to work?