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


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:

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

Thank you.