Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select range from pivot table one field by using input box

Hi,

Please any body let me know how can i select range of the specific field in pivot table  using input box for range selection.

3 Replies
vardhancse
Specialist III
Specialist III

1.Create one variable

2. create one input box using the variable

3. in expression use the variable

So based on the variable value the expression will change.

Not applicable
Author

please can u explain it with Example along with image file because i am using personal version

Thanks

Vasudha

vardhancse
Specialist III
Specialist III

in settings->variable overview->create one variable vExpression(Can be any thing) and give some value to that variable.

now create one input box object using teh variable vExpression.

In chart expressions use this variable so that

Eg: count({<Input={'<=$(vExpression)'}>}ID

So that it will take count of ID where input field is the variable value.

when ever we change value in input box the value in expression will change