sum of values of different rows

[Robert78]

Hi guys,

I have a table loaded like this:

Year/Month/Value

2019/1/4324

2019/2/4335

...

2020/1/43543

2020/2/45454

...

I need to compare in a bar chart sum(value) on year 2019 with sum(value) in 2020

how can I do this ?

pls advice.

thanks.

[dplr-rn]

not compltely clear on the issue.

why not add year as a dimension?

[martinpohl · Accepted solution]

so load

Data:

load

subfield(Datafield,'/',1) as Year,

subfield(Datafield,'/',2) as Month,

subfield(Datafield,'/',3) as Value

from your datasource;

and then create a bar chart,

Year as dimension, sum(Value) as extression.

Regards