How to hide repeated expressions in a "GROUP" dimension

[#1]

Good morning everybody,

Today I'm facing with a very hard problem for me (but hope not for you) as I'm starting thinking I want to upset the rules of SQL...

Attached you can find my QVW.

I just would want to hide the columns where the values are 0.

What do you suggest?

Many thanks everybody!!

Regards.

Fabio.

[Gysbert_Wassenaar]

That's not possible in a pivot table. The expression columns will be shown for every dimension value, in this case of your GROUP dimension. Try using a straight table with four expressions with a conditional expression for each.

[#3]

Thanks Gysbert.

Do you think I could reach such target by creating a pivot table through some script macro or something like that?

Regards.

Fabio.

[Gysbert_Wassenaar]

No, it doesn't matter how you create the pivot table. It just is not possible with a pivot table. Try using a straight table instead.