Create a report with date wise data

[Gokul1]

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)))>>

[AleksiAlkio]

For how many days do you need it max?

[Gokul1]

for a financial year

[AleksiAlkio]

So you could have 365 days in one report?

[Gokul1]

yes

[AleksiAlkio · Accepted 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..