Applying set analysis filters to the column values display in table object

[Tool_Tip]

Dear all,

I have below table object :

If I have filter the data for UK country only in set analysis, the resulting table will be as below :

So, as we are filtering the data for UK country using set analysis the result is showing correct but we also want to display the "UK" in country column filter, now it is still showing all :

[Kushal_Chawda]

@Tool_Tip  create a below calculated dimension

=aggr(Country,Country)

[Tool_Tip]

Hi Kaudhal,

No Luck.

Note: the above is the example, we have multiple dimensions ...not just one

[tresesco]

@Tool_Tip You can use simple if statement for dimension like : If(Country='USA', Country)
Or,
You can write your expression replacing set analysis with 'if statement' and then suppress null values in the chart dimension, in that case you won't need additional expression/restriction for dimension 

[TauseefKhan]

Hi @Tool_Tip,

Use GetFieldSelections  Function:

=GetFieldSelections(Country)

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***