partial sum not displaying correct totals!!! (please help)

[ali_hijazi]

Hello

I got a pivot table with 2 expressions E1, and E2

E1 is sum(sales) * -1

E2 is as follows:

if

          (

                    (BACategoryName = 'Shareholders' & chr(39) & ' Equity and Liabilities' or BACategoryName='Profit of the period') and JvdDataSource='SAP' ,

                                        sum(BAJVDetails.systemDebitAmount - BAJVDetails.systemCreditAmount) *(-1),

                                        if(JvdDataSource='SAP',sum({<JvdDataSource = {'SAP'}>} BAJVDetails.systemDebitAmount - BAJVDetails.systemCreditAmount))

          )

and the dimensions are as follows:

BaCompanyName,

BaCategoryName,

BaSubCategoryName,

FinancialCategoryName,

MonthYear

the expression values are correct however the partial sums do not display correct values

Note:

I tried the Sum(aggr(sum(field),D1,D2,D3,D4,D5)) but still the parital sums are not correct