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?
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
Please find the Attached format which is required.
Where is the raw data . The Excel is all empty
The data can be anything... I just dont want to show Expression W & X for Dimension value c of Dimension D
Please see attached.
Similar to what stalwar1 mentioned.
Each dimension has their own expression that is visible when a dimension is selected.
Retrieving data ...