Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Mohammed Rafi
    Group by Due Date
    Topic posted November 14, 2019 by Mohammed RafiBlack Diamond: 60,000+ Points 
    30 Views, 2 Comments
    Title:
    Group by Due Date
    Content:

    Hi,

    I have output of the report from RTF template as below

    Due Date        Amount
    ----------------------------------

    01/01/2020    1000

    01/04/2020    1000

    01/05/2020    1000

    01/01/2020    500

    01/05/2020    2000

    How can I group by Due Date in template so that the output would be as below

    Due Date        Amount
    ----------------------------------

    01/01/2020    1500

    01/04/2020    1000 

    01/05/2020    3000 

    Thank you

    Comment