how to get running total year month wise
HI All,
Working in Oracle EBS
Version 12.2.10
My requirement is to get year wise running total
query
SELECT CUSTOMER_ID, YR, MNTH, AMOUNT
, sum(AMOUNT) over (order by YR, mnth rows unbounded preceding ) YTD_SALES
FROM
(
SELECT RA.SOLD_TO_CUSTOMER_ID CUSTOMER_ID,
to_char(trx_date,'MON-YY') MONTH_YR
,(to_char(trx_date,'YYYY-MM') ) MNTH_YR
,to_char(trx_date,'YYYY') YR
,TO_NUMBER(to_char(trx_date,('MM')) ) MNTH
,SUM(RACTL.EXTENDED_AMOUNT) AMOUNT
FROM RA_CUSTOMER_TRX_ALL RA
,RA_CUSTOMER_TRX_LINES_ALL RACTL
WHERE RA.CUSTOMER_TRX_ID = RACTL.CUSTOMER_TRX_ID
AND RA.ORG_ID = RACTL.ORG_ID