Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
Help please with my task)
How to calculate sales with month, which is previous from selected month?
some like:
sum({<Month=....>}Sales)
Thanks
Depends on your data model
try sum({Month={$(=month(addmonths(yourdate,-1))}...
or sum({Month={$(=Month-1)}--- if Month is numeric