pivot table question

[#1]

How can I get rid of the empty rows where level 2 and level 3 is empty but i still want to show if there is a level1 or level2

[Anonymous]

Guessing: if Level 2 is empty, Level 3 is empty too (?).  Try to "suppress when value is null" for Level 2.

[#3]

if i suppress level2 than the one level1 goes away for ana6

[Anonymous]

Oh, you want to keep it?  I got your request wrong...  Probably could be done on the expression level, or calculated dimension.  Need some thinking to do, but not now.

I bet someone will answer before I get back to it 🙂

Edit:  actually, got an idea for you to play with - see attached.