What's the problem here?.... I have a table ...

[Michael2]

What’s the problem here?..

I have a table that includes the following columns

Inspector Quarter Total Score (among other columns)

I setup a slice to with the following row filter: (Month(TODAY())/4) + 1=[QTR]

The intent is to filter all rows where the quarter is not the current quarter. When I test this, it works as expected. However, when I attempt to use this slice in any type of view, no data is returned.

The idea is to create a chart view that will return the avg score per inspector per quarter. Unfortunately, I’m at a road block that I can’t seem to get past. Any suggestions would be appreciated.