Hiding a Expression in Pivote Table

[prasad_dumbre]

Hi All,

Can you please guide me in fullfilling below req.

I have attached sample QVW

In this, I want to hide Calulation 2 under Budget , But It should be visible under Actual.

[swuehl · Accepted solution]

A pivot table will show all expressions for all dimension values.

The only way I can think of to achieve something similar is by converting your expressions into an additional dimension and check your ExpressionDim in your single expression to select the correct expression.

Please check attached.

[#3]

Try Set analysis

[#4]

May be this will work

[Kushal_Chawda]

Hi Prasad,

Please find the attched application.

I have used valuelist for required dimension & expression.

Regards,

Kushal chawda

[Kushal_Chawda]

You can further simplify as attched

[prasad_dumbre]

@Swuehl & Kushal,

Can we use this thing where we can put conditions like

=if(WildMatch(A/B,'*Budget*'),0,1)

to achieve the same result ? Coz my actual scenario is too complex & have to think twice before making any mojor changes  in expresions or backend . . .

But still thanks to both of you, as your solutions shown me some way to achieve this. . .