Get Free Trial

Pivot global searchbox

Massimo asked on June 24, 2020

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?

3 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster June 25, 2020

Hi Massimo,
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.

Massimo July 11, 2020

Hello Mykhailo,
Thank you for your answer.
This is the feature’s flow I’ve in mind:

  1. A user wants to find a row (by its field name) that is not displayed in the visible area of the pivot
  2. He starts writing the field name in a global search box
  3. After a minimum number of requested characters (possibly configurable) he can click on the “search” icon to start his search;
  4. The pivot finds any row whose name contains (starts or ends with – possibly configurable) the provided substring and shows it selecting the proper row (even if not visible because is belongs to a collapsed item) and expanding its children.
  5. If more results match the search criteria the pivot shows a next navigation button to scroll through all the results until the last one is reached.

Considerations: It would be nice if this feature will be exposed also via API so that a custom searchbox could be used.

Mykhailo Halaida Mykhailo Halaida Flexmonster July 13, 2020

Hi Massimo,
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.
Best regards,

Please login or Register to Submit Answer