Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to show the panel the cumulative figures for the year to the selected month.
See the attached model.
Hi,
You can use Set analysis like that:
=Sum({<Month={"<=$(=Max(Month))"}, Year_N={"$(=Max(Year_N))"}>} Vol)
Regards,
Aurélien
Hi,
You can use Set analysis like that:
=Sum({<Month={"<=$(=Max(Month))"}, Year_N={"$(=Max(Year_N))"}>} Vol)
Regards,
Aurélien
Thank you!