Hi Team,
Greetings of the day!!
I hope Everyone is doing well!
I am having a requirement in my application as per below mentioned tables
T1:
Product Code | Amount |
1000 | 600 |
1001 | 400 |
1002 | 300 |
1003 | 500 |
1004 | 1000 |
T2:
Product Code | Category |
1000 | Apple |
1000 | Banana |
1003 | Apple |
1003 | Banana |
1004 | Grapes |
By joining this 2 tables i need a output like below
Category | Sum(Amount) |
Apple | 550 |
Banana | 550 |
Grapes | 1000 |
How the calculation need to perform is for product code 1000 the amount is 600 that need to distribute equally to Category same as well as for product code 1003 also.
Kindly help me to resolve this issue.
Thanks in advance
Best Regards,
Krishna
