We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Problem in grand total calculation in pivot table

We are having troubles in some pivot table reports with Grand Total.

Some times, depending of filed combinations in columns or rows we get an inconsistent grand total.

For instance if we generate a pivot table grouped as follows:
- State, City and CityCode at rows
- Year at columns

We get correct sum city totals, but incorrect sum state totals in grand total columns.

To replicate the problem we have attached an example application.

Thanks for your soon help with this issue.

Hi,

Thanks for the sample project to show the issue.

We have logged it into our issue tracking system with an id: CELLSNET-18463. We will investigate the issue and get back to you soon.

Thank you.

Attached is another example of a similar problem with totals.

In this example we have a different set of data but we are groping by using similar fields:

-State, CityCode at rows
- Year at columns

The error in totals is at columns of years 2000 and 2001. This time the sum at the end of this columns has wrong value.

We will appreciate a quick solution for this, due to users are having troubles with this reports.

Thanks.

Hi,

Thanks for providing us another project to demonstrate the issue.

We will look into it and get back to you soon.

Thank you.

There is some update about this issue?

We need some help with this.

Thanks

Hi,


Please try the attached latest version: v2.6.4.2004.

The bug for Calculation error in Grand total has been fixed in the attached version 2.6.4.2004 (GridWeb)

Thank you.

The issues you have found earlier (filed as 18463) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.