Pivot rows disappearing

[xtrimf]

Hi,

I have a pivot table - for each level its different calc...

It is built as a Hierarchial Tree. it means fo all rows the "drill down" is ending in a different dimensionality() (Depth);

the problems:

1 - when expanding a dimension that on a "brach" that has ended - the row disapear.

2 - also other rows disapear.

Attached is an example.

is there a way for rows not to disapear(I have to use suppress null values) ?

[alexandros17]

IN your expression you have to add the second condition that is:

(if(Level = Dimensionality(),Value,0))

...

It works

Hope it helps

[xtrimf]

Hi,

It didnt work for me...once I expanded >-a->b->

most of the rows disapeared....

[xtrimf]

In cluding the 'b' row ...and i still have to keep the original value when its not disapearing....

[alexandros17]

Uncheck suppress 0 value in presentation tab

[xtrimf]

I did...

[alexandros17]

Take a look to the modifyed document

[xtrimf]

I'm sorry - I can't see what has changed.

in "calc ver 1" when you expand it still disappears (at least on my computer...)

[xtrimf]

anyone?

[dasilva]

Hi,

Have you found a solution?

What version of QV are you using? Do you have the same problem if you create a pivot table with the same calculation for all dimension (but still use "show all values")?

I'm having this problem in pivot tables (QV 11 SR2) and wonder if it might have something to do with "Show all values"!?

Cheers,

Ulli