2 subtotals for 2 groups

Aspose.Cells Product Family
1

Dear All,


I want to have 2 subtotals for 2 groups… I tried:

cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 3, 4, 5, 6, 7, 8, 9, 10 }); // Year Summary
cells.Subtotal(ca, 1, ConsolidationFunction.Sum, new int[] { 3, 4, 5, 6, 7, 8, 9, 10 }); // Branch Summary

but it does not work … (

please help

many thanks in advance
2

Hi Winanjaya,


Thank you for contacting Aspose support.

Please provide your expected results in a spreadsheet, that you may create manually using the MS Excel application. By reviewing your expected results, we will try to mimic the functionality with Aspose.Cells API.