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

[ali_hijazi]

Hello

I got a pivot table with 6 dimensions D1, D2, D3, D4, D5, and D6 and several expressions

expression one (E1) is very simple; I'm displaying the sum(amount) - I'm displaying the result using INTERVALMATCH from an excel sheet

however I put a condition in E1 saying that if the value of a row under dimension 4 is equal to X for example and that the value of the variable V is negative $(V) < 0 then display sum( {<FiscalYear = {'2009}> amount)

V is defined as follows Sum( Total {<D4={'X'}>} amount)

now everything is working just fine except for the following

if the pivot table is fully expanded then the values for E1 are all correct (I got 2 rows for the value X of D4 with 45 and 50 as values) - this is correct

However if I collapse the pivot table at the level of D4 the partial sum instead of showing 95 it is displaying another number which I don't know what it is

how can I solve this problem

please help

[#2]

Hi there, try using the aggregate function, so that it calculates over each value of D4, like this:

sum(aggr(your expression,D1,D2,D3,D4,D5,D6))

Regards