How to sum only the values of the last month

[#1]

Hi,

I have customers with sales and credits by year, by month. I want that when the user is selecting multiple months to sum only the sales of the last month.

I tried without succes a formula like this :

sum({$<Month ={vMonth}>} Sales)

where vMonth is a varibale that calculates the max(Month)

If someone has another idea I'll apreciate.

Thanks

[m_woolf]

Try:

sum({$<Month ={'$(vMonth)'}>} Sales)

[MayilVahanan]

Hi

     sum({$<Month ={'$(vMonth)'}>} Sales)

Hope it helps

[#4]

Hi,

I tried this but is still not working.

Thanks

[#5]

I fund myself the answer, I should use an if, like this :

sum(if(Month=vMonth, Sales ,0))

Thank you!!!