We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Showing Aggregation of data inside Table

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 ?

Hi Sonia,

Thanks for your inquiry.
Aspose.Words for .NET is a class library that enables your applications
to perform a great range of document processing tasks. Aspose.Words
supports DOC, DOCX, RTF, HTML, OpenDocument, PDF, XPS, EPUB and other
formats. With Aspose.Words you can generate, modify, convert, render and
print documents without utilizing Microsoft Word®. Please check more
detail from here:
http://www.aspose.com/docs/display/wordsnet/Introducing+Aspose.Words+for+.NET

I suggest you please use the mail merge feature to achieve your requirements. In this case, you data source should contain sum of quantity column. Please read about simple mail merge and mail merge with regions from here:
http://www.aspose.com/docs/display/wordsnet/Simple+Mail+Merge+Explained
http://www.aspose.com/docs/display/wordsnet/How+to++Execute+Simple+Mail+Merge

http://www.aspose.com/docs/display/wordsnet/Mail+Merge+with+Regions+Explained
http://www.aspose.com/docs/display/wordsnet/How+to++Execute+Mail+Merge+with+Regions

You may use { =SUM(ABOVE) } formula field to sum the values of a table’s column. See the attached template document for your kind reference. Hope this helps you. Please let us know if you have any more queries.