Data filter

[Anonymous]

Hello,

Could you help me in solving of my request:

I have straight and pivot tables and I need to filter data by some values. For example, I have a table as showed below and I need to show for user only entries if the values in column "MatchStatus" do not equal to 'FT' or 'AT'

Match         MatchStatus

1               FT

2               AT

3               3

4               45

Thank you!

[stabben23]

Hi,

then use set analysis. Likethis:

sum({<MatchStatus -={'FT','AT'}>}YourValue)

[Anonymous]

Hi,

Thank you. I can use it for Dimension and Expression? Parameter YourValue what means? 

[stabben23]

This should be use in Expressions.

Expressions With set analysis will reduce Dimensions for you.

Set analysis should not to be use in calculated Dimensions.

YourValue is Your value that you want to aggregate.

[Anonymous]

OK, its clear. If I do not need to aggregate any data - only to filter entries in my table.

[stabben23 · Accepted solution]

Then use this as Expression for ex:

Only({<MatchStatus-={'FT','AT'}>}MatchStatus)

Match as Dimension

[Anonymous]

Thanks. I'll check later and let you know how it works.

[balabhaskarqlik]

May be:

If(Not Match(MatchStatus,'FT','AT'),'MatchStatus')

[Anonymous]

As you see there is an error when I use proposed solution. Do you have any ideas why it does not work?

[Anonymous]

Thank you, but proposed solution does not filter data and shows every entry however FT entries replace by "-". Do you have any ideas how do not show entries by this criteria?