'Total' on excel export is incorrect

[yashcena]

Hi,

I have a chart in which I'm showing Application Name and Total Hours. When I enable the partial sum, I get the sum of total hours.

But when I disable the partial sum, export it and take the sum of 'Total Hours', that figure is totally different.

I think whatever properties/options are applied on the chart, those would still be applicable on the exported dataset (like supress when value is null etc.)

I mean if the nulls are supressed in the chart, then the exported dataset would also have nulls supressed. 

Has anyone come across this issue.

Any help would be appreciated!

Thanks,

YASH

[pradosh_thakur]

As you said you are enabling partial sum you must be using Pivot table. To get the totals you might need to use an aggr() function.