Function / Method to Filter a list of Value in a dimension in Straight table

[#1]

Is there a way to to Hide / Filter a specific Value in the straight table dimension.

Ex:

Country

USA

UK

France

Canada

Japan

and I want to filter the Value say (Japan) from the straight table.

Best -

SA

[#2]

Hi,

If you got correct answer then mark it as correct and close the discussion

[#3]

Thanks Jagan

Sorry for the delayed response,, It works Excellent.

Thanks -

SA

[jagan]

Hi Syed,

Please close the disucssion by giving Correct and Help answers to the posts.  So that it helps others to find solutions to the similar type of requirements.

Regards,

Jagan.

[#5]

Correct Answer

[jagan]

Hi Syed,

Click the Correct and Helpful Answer buttons in the posts which gives the solution.

Regards,

Jagan.

[rafaeljmvicente]

Thanks, it worked.

For more complex formulas

=Sum({$<Region={'APAC'}>} TeoFDCost ) / Sum({$<Region={'APAC'}>} (TeoFDCost-FCVCostBW) )