Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
alemberg
Contributor III
Contributor III

Dimension exclude filter

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. 

1 Solution

Accepted Solutions
marcus_sommer

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

- Marcus

View solution in original post

1 Reply
marcus_sommer

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

- Marcus