topic Re: Filter on measures within a pivot table, input control option in App Development

Filter on measures within a pivot table, input control option

msshawn3019 — Wed, 27 Jul 2022 16:58:08 GMT

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.

Re: Filter on measures within a pivot table, input control option

edwin — Wed, 27 Jul 2022 20:41:45 GMT

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

Re: Filter on measures within a pivot table, input control option

edwin — Wed, 27 Jul 2022 20:45:17 GMT

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

Re: Filter on measures within a pivot table, input control option

edwin — Wed, 27 Jul 2022 20:46:07 GMT

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

Re: Filter on measures within a pivot table, input control option

msshawn3019 — Tue, 02 Aug 2022 16:06:57 GMT

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.