Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to sum sales by accumulated date in expression.
I have data from the period 2019-2023, but I need to filter them in the query only to:
- the current year
- from 01.01 to the present day
And I know, the current year would be enough, but the graph cannot react to any other filters related to days/weeks/months/date etc.
My current expression:
Sum( {<$(=year(today()))>} Sales)
My solutions in edit expression:
Sum({<MonthNbr={"$(= '=' & (Max(MonthNbr)))"}, Year={"$(=(Max(Year)))"}, Day={"$(= '<=' & (Max(Day)))"}, Data=>} sales)
My solutions in edit expression:
Sum({<MonthNbr={"$(= '=' & (Max(MonthNbr)))"}, Year={"$(=(Max(Year)))"}, Day={"$(= '<=' & (Max(Day)))"}, Data=>} sales)