Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Gysbert!