Forum Discussion

mahendran2006's avatar
mahendran2006
Frequent Visitor
2 years ago

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...
Need Help
mahendran2006's avatar
mahendran2006
Frequent Visitor
2 years ago
weekInvoiceInvoice refresh datemax refresh date
WKS 01st Apr 202411114/5/2024John
WKS 01st Apr 202422224/5/2024Peter
WKS 01st Apr 202433334/5/2024Charles
WKS 01st Apr 202444444/5/2024Cathy
WKS 08th Apr 202411114/8/2024John
WKS 08th Apr 202422224/8/2024Peter
WKS 08th Apr 202433334/8/2024Charles
WKS 08th Apr 202444444/8/2024Cathy
WKS 22nd Apr 202411114/22/2024John
WKS 22nd Apr 202422224/22/2024Peter
WKS 22nd Apr 202433334/22/2024Charles
WKS 22nd Apr 202444444/22/2024Cathy
  • mahendran2006's avatar
    mahendran2006
    Frequent Visitor
    2 years ago
    MonthInvoiceRefresh DateName

    Apr'24

    		11114/22/2024John
    Apr'2422224/22/2024Peter
    Apr'2433334/22/2024Charles
    Apr'2444444/22/2024Cathy