how to add filtered dimension

[srikantj]

i have straight table fileds country ,type, id, order with blank expression

when i add country dimension i dont want to add whole country .. i want to add only country-->india

not all contries

how can i add filtered dimension

Qlllikkkks ... Suggest

[Kushal_Chawda]

Use set analysis in your expression

=Sum({<Country={'India'}>}Amount)

[sunny_talwar]

May be like this

If(Country = 'India', Country)

[surendraj]

Use the set expression in Stright table

Count(<{ country={'india'}>}id)

[sunny_talwar · Accepted solution]

Seems like that op have blank expression.... May be this

Avg({<Country = {'India'}>} 1)

and then hide the expression from the Presentation tab?

[sravanthialuval]

Create one calculated dimension for County using below expression

if(Country='india',Country)  and enable suppress when value is null option.