Showing Aggregation of data inside Table

[soniasingh]

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 ?

[tahir.manzoor]

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.