Pivot Table Sigma Values

Aspose.Cells Product Family
1
Can anyone assist on a small problem I have please.

I've created a PivotTable but want to replicate the "[Sigma] Values" (Months) column that is automatically generated in Excel (in the Column Labels).

My data has hundreds of rows, each with a unique DateField. I want to count rows in month columns. When I add DateField to the Pivot table's columns, I get hundreds of columns. I have attached a small example.
But I want them collapsed by month like happens when you are using Excel on the desktop. If I drop DateField into the columns section on the desktop, the Months field is automatically generated.
Thanks for your help!

2

Hi,


Thanks for your posting and using Aspose.Cells.

We have seen the difference between your pivot tables but we only partially understand your problem. Please share your sample code, source excel file, actual output excel file generated with Aspose.Cells and expected output excel file created with Microsoft Excel.

Please also guide us step by step.

1 - Enter “Abc” in cell A1
2 - Select field 3 and select the values ab, cd, ef.

etc

All these things will help us look into your issue more closely and precisely and we will be help you asap. Thanks for your cooperation in this regard and a have a good day.