'Need help in calculating YTD(Year to Date) Invoice amount and Monthly Invoice amount in the same row. Whereas we can get input as 'MON-RR' ex. JAN-22

RA_CUSTOMER_TRX
RA_CUSTOMER_TRX_LINES_ALL

These are the base table. I am using.

Output Example:

Sales_Person	Product(Set of multiple Inv Item)	Mon_Inv_Amount	YTD_INV_AMOUNT
XYZ	Product123	10000	180000

(Assuming report is running on 18-Dec-21)

oracle

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source