Hello DOJO

We are trying to display multiple data state inside a LCA dashboard.
We need to display the data for one element (selected from a table).

Adding many states components is tedious and take to much place (near of 30 data values to display)

First try by using one state component and using a query

1.  The query is used for a table, and table parameters for a state component.
   It's extremely long to grab result because many data are located in many different tables and many join are used in the query.
2. it's not possible to get automatically the title name of each parameter in the state component.

Second try by using the pivot table component.

1. Result is pretty quick
2. All data could be visible and readable easily.
3. Parameters name are automatically displayed.
4. But all elements that are attached to the protocol parameters are displayed (more than 1000)

The questions:
Is there a way to filter the elements in the pivot table, depending on what is dynamically selected inside the LCA dahboard ?
Is there a better way to achieve this ?