Summary of Grand Totals problem

Aspose.Cells Product Family
1

I’ve created an pivot table from a data sheet that has been created from scratch.

Some of the data rows look like the following:

ID Name Investment CustomValues
1 MyName 50 Car
1 MyName 50 Bicycle
1 MyName 50 Train

The grand total of this in the pivot table will be 150, but I would like it to actually be 50 since it’s the same ID (meaning I want to group the three rows by the ID and only count the investment once since it’s only one investment for the ID).
Perhaps the data sheet is wrong and I need to do something else to represent the CustomValues {1:many} relation?

If anyone could help out, it would be much appreciated!
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and try the latest version:
Aspose.Cells
for .NET v7.2.0.1
and see if it resolves your problem.

In order to look into this issue, I need your sample code and the actual output file and the expected output file.

Please note, the code should be runnable and please remove any unneeded code.

You can create expected output file using Ms-Excel manually.

Your actual and expected output file will help us look into your problem and provide you a sample code to resolve this issue.