Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I calculate the sum of CA for all last year
sum((last year) ca ) ?
Sum({<Year={$(=YEAR(TODAY())-1)}>} CA)
Sum({<Year={$(=Max(Year)-1)}>}ca)
Sum({<Year={$(=YEAR(TODAY())-1)}>} CA)
How do you calculate the SUM for ALL previous years? If the user selects the Year 2021, he will see two KPIs: (1) TOtal sales for 2021; (2) Total sales for all previous years (2015-2021)? thank you!