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

ali_hijazi — Mon, 01 Aug 2011 08:01:56 GMT

Hello

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

E1 is sum(sales) * -1

E2 is as follows:

(

(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

topic partial sum not displaying correct totals!!! (please help) in QlikView