Revenue and % change in one chart

[#1]

Hi,

I'm trying to build a chart (like the one below) showing montly revenues and % change but I cannot get the right expression of the change. Any ideas?

Regards,

Ivelin

[Gysbert_Wassenaar · Accepted solution]

revenue: sum(revenue)

% change: sum(revenue)/above(sum(revenue))-1

You'll have to use a secondary axis for the % change expression or you'll have a line hovering between 0 and 1

Also you won't have a % change value for the first year

[#3]

Thanks Gysbert!