Filter on measures within a pivot table, input control option

[msshawn3019]

I have a pivot table that looks something like image providedpivot table score variance.

The calculated value after the colon (:) looks like this: Avg([Agent Score])-Avg([Company Score])

I want to be able to filter on the positive/negative values (i.e. up/down arrows); I'm thinking I might need and input control but not sure where to even begin.

[edwin]

this looks like an extension, perhaps identifying the extension will be useful

[edwin]

in general your question is how do you filter your dimensions based on an on-the-fly calculation.  on high level i would create a variable/field that holds the selected condition - UPWARD or DOWNWARD

then in your pivot you turn your measures on and off:

if no selected direction, show the regular expression you have

if upward, show a measure that computes for when your condition is going upwards

if downward, show a measure that computes for when your condition is going downwards

[edwin]

if you have sample data i or someone else can help you

[msshawn3019]

I've attached a copy of the app.  Any advise on the up/down variable suggestion would be appreciated.  I was leaning in that direction and putting the variable values into an input control but I've never done anything like that before.