Dear Helpdesk,
We are facing an issue in creating a table while PDF generation from WORD Template where we have to show groups on the basis of any column in table.Additionally we have to show aggregation of data.
For example we have columns Item,Country,Quantity and we have to do grouping on the basis of Item and get the total of Quantity.Please refer to below table:
Item | Country | Quantity |
---|---|---|
Item1 | US | 100 |
Item1 | India | 200 |
Total | 300 | |
Item2 | US | 200 |
Item2 | India | 300 |
Item2 | Australia | 200 |
Total | 700 |
Can you please suggest something here how this grouping can be done ?