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) ?
