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

Ignore dimension when using first sorted value

Hi all,

I have an issue while attempting to ignore month selection when using first sorted value function.

My expected output is :

When Month is selected, Q1-Q4 should not be filtered.

 FSV1.PNG

Now when Month(Jul) is selected, Q2-Q4 is filtered out.

 FSV2.PNG

How can I achieved the result where:

When month is selected, Q1-Q4 still remains as well?

The expression looks like this:

FSV3.PNG

Thanks and regards,

Arthur Fong

Labels (1)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

Fixed. Thanks all.

FSV4.PNG

Current expression looks like this:

FSV5.PNG

View solution in original post

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

Fixed. Thanks all.

FSV4.PNG

Current expression looks like this:

FSV5.PNG