Smart Markers for Excel - grouping

Aspose.Cells Product Family
1

How to calculate and display Subtotal for column that does not appear in Excel template?


semple Excel template:

Column1 | Column2 | Column3
&=T1.Col1 | &=T1.Col2(group:repeat,skip:1) | &=T1.Col3_Value

&=T1.Col4(subtotal9:T1.Col2) | | &=subtotal9:T1.Col2



&=T1.Col4(subtotal9:T1.Col2) - we tried to do so, but it doest not work


2
Hi,

"&=T1.Col4(subtotal9:T1.Col2"
Well, the details rows of Col4 will and should also be appeared, and then an extra row would be inserted to insert the Subtotal column. You might not have understand the logic/model for the smart markers grouping data feature. Please check the topic:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/smart-markers.html


Note: To better understand the model, please see the two examples under "Grouping Data" sub-heading for your understanding.

Thank you.