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

Free Support Forum - aspose.com

Smart Markers for Excel - grouping

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


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.