Let's say I have an Excel sheet with A, V1 and V2 columns... I would like to create a PivotTable that would :
- create a single line for each value in the A column
- display for this line the sum of V1 values and V2 values
For now I'm able to create two lines for each value of A (one for the V1 total, one for the V2 total). In Excel I can drag /drop the "Data" header to the "Total" header and I've got then a single line for each value of A with a "Sum of V1" and "sum of v2" headers... The macro created by Excel for this is :
With ActiveSheet.PivotTables("Tableau croisé dynamique2").DataPivotField
.Orientation = xlColumnField
.Position = 1
I attached a file that shows the final result i would like to get.
Can I do the same with Aspose.Cells and if yes how ? Thanks in advance.