Hello Everyone,
I have a data of three products containing Qty, Sale Price & Value(As shown Below).
| Product Name | Particular | UOM | Value |
| A | Qty | MT | 100 |
| B | Qty | MT | 150 |
| C | Qty | MT | 200 |
| A | Rate | Rs/MT | 800 |
| B | Rate | Rs/MT | 900 |
| C | Rate | Rs/MT | 600 |
| A | Value | Rs/Lacs | 0.80 |
| B | Value | Rs/Lacs | 1.35 |
| C | Value | Rs/Lacs | 1.20 |
What i wanted to do is, i want a row generated automatically after every category of Particular column i.e. after qty, rate & Value respectively. Than on the inserted row i wanted to calculate sum & Weighted average, Sum for all the 3 products , Weighed average Rate for Rs/MT and sum of value. What i wanted is shown below in Red colour:
| Product Name | Particular | UOM | Value |
| A | Qty | MT | 100 |
| B | Qty | MT | 150 |
| C | Qty | MT | 200 |
| Total | Qty | MT | 450 |
| A | Rate | Rs/MT | 800.00 |
| B | Rate | Rs/MT | 900.00 |
| C | Rate | Rs/MT | 600.00 |
| Total | Rate | Rs/MT | 744.44 |
| A | Value | Rs/Lacs | 0.80 |
| B | Value | Rs/Lacs | 1.35 |
| C | Value | Rs/Lacs | 1.20 |
| Total | Value | Rs/Lacs | 3.35 |
Please help me for completing the above task.
Thanks & Regards,
Ashish
