PIVOT - Get total Sum of column

Aspose.Cells Product Family
1

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.

2

@sitizalekoh,

Thanks for your query.

See the document on how to use consolidation functions for pivot fields in pivot table report for your reference:

Hope this helps a bit.