I’m looking for a global search box that allow a user to find a specific label and its corresponding row when these are too many. For example, in the Pivot Table demo this search box should enable an end-user to find “Poland” (row 17, col 1) and automatically select that cell expanding its children.
Is there any way to have such a feature?
Thank you for posting your question.
While we think it might make sense to implement something like a pivot table search, it would help us if you could provide more details on your suggestion.
More specifically, do you think you could tell us a little bit more about your specific use-case, what you imagine the flow of this feature’s use to look like and what exact info the end-user should eventually receive?
Any additional information on your vision would help us evaluate whether it would be possible to implement this.
Looking forward to your response.
Thank you for your answer.
This is the feature’s flow I’ve in mind:
Considerations: It would be nice if this feature will be exposed also via API so that a custom searchbox could be used.
Thank you for describing your perspective in detail.
After some discussion with our development team, we’ve come to the conclusion that the search box functionality similar to what you’ve suggested might be somewhat problematic to implement due to particular technical specificities of the pivot table.
With that in mind, we would like to first suggest a different approach for this which, as it seems to us, might be a viable solution as well.
More specifically, the
liveFiltering option can be used to filter the displayed hierarchies by their members at runtime. When
liveFiltering is set to
true, each hierarchy caption is followed with a search box that allows you to search the corresponding hierarchy for specific members while also applying the necessary filters to only display the searched members’ data at a time.
Feel free to check out the corresponding sample illustrating this functionality. Do you think this is something that might suit your use case?
Please let us know what you think.