Excluding Selection

[#1]

Hello all,

I have the following in my dimension:

if( (Store_Latitude > vLatMin and Store_Latitude < vLatMax)  and ( Store_Longitude < vLonMax and Store_Longitude > vLonMin ), Store_FullName,null())

What is does is show all the stores within a radius of a selected Postal code. Works perfect except ...

When I associate Postal Code table with Store Table and others, the results are limited to just those in the area code.Is there a way I can/should exclude Postal Code from limiting the results?

[SunilChauhan · Accepted solution]

in expresion try use below

sum({<[Postal Code]=>}fieldname)

in above  [Postal Code]=

used to exclude selection

hope this helps

[#3]

Thank you Sunil,

I knew it was going to come down to using set analysis; although I was hoping to do it another way. I did use what you said in a text object and it worked.

=Count({<[PostalCode_PostalCode]=> }distinct if( (Store_Latitude > vLatMin and Store_Latitude < vLatMax)  and ( Store_Longitude < vLonMax and Store_Longitude > vLonMin ), Store_FullName))