Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I want to present a ComboChart where I could show the variation (%) for each consumable, from the last year to this one.
In general, something like the image below.
Any ideas about which formula should I use?
Thanks
Put only Month as a dimension (not year-Monthy), consumable as second dimension
and as a measure, sthing like:
(sum({<Date,Month,YearMonth, Year={"$(=max(Year))"}>}Value)
-
sum({<Date,Month,YearMonth, Year={"$(=max(Year)-1)"}>}Value))
/
sum({<Date,Month,YearMonth, Year={"$(=max(Year)-1)"}>}Value)
Thanks for your reply!
However, still some doubts:
In this part: "$(=max(Year))" , The $ stands for what? Should I use it just like that?
Thanks