Skip to Content
0
Former Member
Sep 22, 2014 at 12:02 PM

Calculating Sales YTD

45 Views

Hi All,

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.

Thanks

Raj

Attachments

Datafolw.JPG (34.8 kB)