Option to remove filter?

[Anonymous]

I am working on a report chart that shows aggregated data for the last 10 work days. This means that there are 10 rows, one for each day. Currently, when I add the field for state, it is only 10 rows long when a single state is selected. I cannot "unselect" a state in order to look at all of the aggregated data, and if I select all then my table becomes 500 rows, 10 for each state. I would like for the report to be filterable by US state while remaining 10 rows long.

I tried adding a filter chart to do exactly this, but it added the column for states. Is there another way I can achieve what I am looking for?

[effinty2112 · Accepted solution]

Hi Matthew,

Don't add State as a dimension of the chart use a separate listbox to select the State(s) you want to look at.

Cheers

Andrew

[Anonymous]

Thank you, this worked. Swore I had tried this already but I tried it again and all was fine.