Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, when selecting date 25/3/2022
it gives a sum(sales) up to 6 months like below
From 25/3/2022 to 25/9/2021
Try a solution like:
sum({<Date={"$(>=Date(AddMonths(Max(Date),-6),'DD.MM.YYYY'))<=Date(Max(Date),'DD.MM.YYYY'))"}>} sales)
Probably it needs to be adjusted a little but is a good starting point
Try a solution like:
sum({<Date={"$(>=Date(AddMonths(Max(Date),-6),'DD.MM.YYYY'))<=Date(Max(Date),'DD.MM.YYYY'))"}>} sales)
Probably it needs to be adjusted a little but is a good starting point