Dimension exclude filter

[alemberg]

Hello folks, I am trying to figure out the following.

I have a straight table with about 10 columns. One of those is "Property Type", and lists out types of properties we have in our data set. I would like to create an instance of this straight table for comparison purposes, where the column removes whichever "Property Type" is selected from the Drop Down filter. 

For instance, if a user selects "Single Family" from the filter, then the table will show all the other types EXCEPT this one. 

I believe there was a {-1}, but I cant seem to come up with the correct expression

Is this possible and how, thank you in advance. 

[marcus_sommer · Accepted solution]

Try it with e() like: sum({< "Property Type" = e("Property Type") >} Value)

- Marcus