Sum aggregation did not match

[ecabanas]

Hi,

I did a pivot table with several dimensions and trying to check the values I saw that the grand total did not match if you sum manually (see the screenshot attached)

Did anybody how to fix this calculation?

Thanks

See the aggregation screenshot

[sunny_talwar]

What expression are you using?

[ecabanas]

this is the expression

Sum({<[SalesId]={"PV0***"}>} Import_Brut)

thank's

[sunny_talwar]

This is strange, the sum should have been correct.. are you sure you are not rounding the numbers before exporting it to Excel?

[ecabanas]

no, no the exportation is correct, there are 4 dimensions and one measure

The measure is really simple 

Sum({<[SalesId]={"PV0***"}>} Import_Brut)

thank's for your help

[sunny_talwar]

I see the issue, but I am not entirely sure what might be going on. May be someone else is able to help here