Hide Particular Expression for a Dimension value

[shanky1907]

Hello All,

I have a situation.

I have 4 Dimensions as A, B, C, D &

For Expression as W, X, Y, Z.

I have taken A,B,C horizontally and D vertically.

Now if D has three values a , b , c.

Now for c i only want to show expressions Y,Z.

How i can i achieve this in pivot chart?

Can anybody help?

[sunny_talwar]

You will need to use Pick(Match(...)) with synthetic dimension/island table field to accomplish this. If you can provide a sample of your raw data and your expected result, we might be able to help you better here

[shanky1907]

Please find the Attached format which is required.

[sunny_talwar]

Where is the raw data . The Excel is all empty

[Anonymous]

Hi,

Please see attached.

Similar to what stalwar1‌ mentioned.

Each dimension has their own expression that is visible when a dimension is selected.

[shanky1907]

The data can be anything... I just dont want to show Expression W & X for Dimension value c of Dimension D