Parial sum issue

[mario-sarkis]

Hey all Please find attached excel sheet my problem is that the partial Sum in a pivot as it shows in my example in the 'Y' Field

if you calculate the it less then it shows.

Please help

[Kushal_Chawda]

try aggr fucntion

sum(aggr(sum(Value),Dimesion))