i wanna create a date wise report between two dates, formula:<<SUM(SELECT(Order_Item[NALAM_LOADING_CHARGES],And([Sender_Type]=โNalamโ,[LOADING_DATE]=[REPORT_DATE],[LOADING_RESPONSIBILITY]<>" ",[DECIMAL_2]>0)))>>
i wanna replace the[REPORT_DATE] with a list of dates
Date | charges |
01-01-2024 | <<SUM(SELECT(Order_Item[NALAM_LOADING_CHARGES],And([Sender_Type]=โNalamโ,[LOADING_DATE]=โ01-01-2024โ,[LOADING_RESPONSIBILITY]<>" ",[DECIMAL_2]>0)))>> |
02-01-2024 | <<SUM(SELECT(Order_Item[NALAM_LOADING_CHARGES],And([Sender_Type]=โNalamโ,[LOADING_DATE]=โ02-01-2024โ,[LOADING_RESPONSIBILITY]<>" ",[DECIMAL_2]>0)))>> |
Solved! Go to Solution.
Create an additional table with one column [ID]. Add number from 1..365. Table name is "Days". Then you need to have a "Request" table with [Start] and [End] date columns.
Finally you can create the dynamic report with something like this..
For how many days do you need it max?
for a financial year
So you could have 365 days in one report?
yes
Create an additional table with one column [ID]. Add number from 1..365. Table name is "Days". Then you need to have a "Request" table with [Start] and [End] date columns.
Finally you can create the dynamic report with something like this..
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |