Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Expression to show N/A when a dimension is selected

Hi all,

I have a requirement to show 'N/A' for a specific dimension value throughout the months. 

Below is the expected output (without selection):

          Month for Feb, Jun, and Oct are displayed as 'N/A'.

WithoutSelections.PNG

 

I would also want to achieve the desired output when Month is selected:

For example when i select Apr, Month for Feb, Jun, and Oct should be displayed as 'N/A'.

But I couldn't achieve the expected result.

WithSelections.PNG

Kindly leave any valuable comments.

The qvw is also attached below.

 

Thanks and regards,

Arthur Fong

 

Labels (3)
0 Replies