Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to have in one graph Table the sum of the costs BY YEAR and the costs for December of the last year.
I have for dimension Year, and for the 1st expression : sum(Costs) --> Easy
But for the sum of the costs for december, this expression does not work :
sum({<Year={"$(=Addyears(Year,-1))"}, Month={12} >} Costs)
I join you the sample file to help me.
Thank you veeery much !
Hi, try this in this situation.
Sum({<Year = {"$(=Year(Today())-1)"}, Month = {12}>} Costs )
Thank you for your answer.
But I think this will work only for the last year (ie. 2023)
What if I need this for all the different year ?