Forum Discussion
summarize table by max date
Hi All, I have two tables, date table and invoice table. my requirement is to show the unique recent invoice data by refreshed date. if i put week column from date table it has to show the uniqu...
Hi Greg,
Thanks for your reply. i have shared the input and output tables. i have the daywise data. if i want to view the data weekly data has to be grouped within that week and has to give the recent refreshed date data.
if i want to view the data monthly data has to be grouped within that month and has to give the recent refreshed date data . in a similar way it has to give for quartely, half yearly, yearly