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

Free Support Forum - aspose.com

PIVOT - Get total Sum of column

Hi. How can I get the Σ-values in pivot using C# or vb.net?
For example, I want to get the Σ-values of column “Amount ($)”.
Sorry for the silly question, it just because I really don’t know how to get it. I do google it but don’t find the answer. Thanks in advance.

@sitizalekoh,

Thanks for your query.

See the document on how to use consolidation functions for pivot fields in pivot table report for your reference:
https://docs.aspose.com/display/cellsnet/Consolidation+Function

Hope this helps a bit.