Show only the "string values" I select tp show on the dimensions (X) axis

[nicouek]

Hello all,

I have a field [CODE] in my data, let's say the values in [CODE] are: sunny, rainy, overcast,  cold, humid and dry. My dimension (x) axis will be shared by [CODE] and [Month]. My (Y) axis measure, is represented in percentage(%) to show "what percentage in month did each [CODE] value occurred"; however I would only like to only show dimensions for "Sunny", "Rainy" and "Overcast". All the values in [CODE] are all currently showing on my legend and dimension axis, I would only like to show and measure 3 of then. Is it possible? is so can you please help. Thank you 

[Kushal_Chawda]

@nicouek  If you have measure like sum(Value), then you can try below set analysis in your measure

=sum({<CODE ={'Sunny','Rainy','Overcast'}>}Value)

[nicouek · Accepted solution]

Thank you Kushal for your response did not quite do the trick, perhaps I did not explain to problem adequately. However I had a colleague assist me with it, he came up with this:

  From the script line:

 "code",
    if("code"='Sunny (Permanently)', 'Sunny',
    if("code"='Rainy (Permanently)', 'Rainy',
    if("code"='Overcast (Around)', 'Overcast',
   
  null())) as "FIELDNAME FROM THE DATA SOURCE",

And it worked.

Thank you anyway for your help