Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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