PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...
ExcelPivotTable.Calculate(refresh) Calculates the pivot table. Parameter 0 - if true the cache will be refreshed before calculating. If false the existing cache will be used. If no cache exists the ...