I have one table called F_SALES_TRANSACTION where all sales invoices data's are stores.
I have one more table called F_SALES_MONTHLY where I need to calculate NET_AMOUNT_YTD.
I am using below data flow -
> Source - F_SALES_TRANSACTION
> Query Transform
> Group By Transform
> Key Generation Transform
> Table Comparison Transform
> Target - F_SALES_MONTLY.
But I am not able to calculate NET_AMOUNT_YTD . If need more information please let me know.
Can you please help me ? After which transform i should calculate YTD.