Restriction in dimension

[everest226]

HI i have a Pivot table in Sense with two dimension , 

Country Name and   Country Name  & '-' & [New PST]

now i want to exclude  value from  [New PST]      which are  ABC and CBA 

the result i am getting is i can exclude those value but i am still getting county name  associate with that value.  

[sunny_talwar]

How exactly are you excluding them?

[everest226]

I created new field in script to exclude them, Field name as [New PST]. 

So basically its already exclude , but i am still have Country name associate with that .

[sunny_talwar]

Why don't you exclude it via set analysis?

[everest226]

I have exclude that on measure using set analysis , i still see country name associate with those value , getting 0 on all measure.  

[everest226]

=[Country Name] & '-' & [New PST]     this is my expression for second dimension     

[sunny_talwar]

I am not sure I follow your comment. Can you show this via sample or images?

[everest226]

Again first dimension   [Country Name]      and second dimension  =[Country Name] & '-' & [New PST]

[sunny_talwar · Accepted solution]

May be try this

If(Len(Trim([New PST])) > 0, [Country Name] & '-' & [New PST])

and then make sure that you uncheck 'Include Zero Values' for your dimension

[everest226]

Thanks Again it just worked fine