
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please can u explain it with Example along with image file because i am using personal version
Thanks
Vasudha

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
