Using Pick to select Different DIMENSIONS for set analysis

[thakurdagautam]

Hello, I am trying to use the Pick Function in a chart where i can change the dimension in the dimension field of  a bar chart. but Pick function isnt picking it up. It is working with nested ifs, however.

I have used Pick function to change the measure values and i thought it would work the same for the Dimensions, but it isnt.

how to resolve this?

[AshutoshBhumkar]

Hello,

On what action are you changing the dimension ?

You can show 1 dimension at a time in bar chart and Pick() takes an integer from 1 to n to show values.

Thanks,
Ashutosh

[thakurdagautam]

i was trying to replace dimensioins on the basis of pick. i have found the solution. it goes as follows:

Pick($(variable),Dim1,Dim2,....DimN)