Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Guys,
Kindly respond it and let me know this scenario is it possible or not.
Thanks,
Krishna