Skip to main content
Question

Pivot grid details

  • November 7, 2025
  • 4 replies
  • 34 views

Forum|alt.badge.img+8

As an example case we have a pivot grid with sales orders that default is grouped by customer, but the user is allowed to change the cube view. So for example he could remove the customer category, but group on order type instead.

How can we make it possible that the user could open specific orders when the orders are aggregated in the pivot grid? We tried adding a detail tab with the orders, but it will only show the first row.

Of course double clicking on a pivot grid cell opens a popup that shows all the orders of the aggregation, but we cannot use that to open the orders with all details (I created an idea for that: Pivot grid zoom in - normal grid functionality | Thinkwise Community).

The only thing I can currently think of is creating a field with a html link that points to a deeplink of the order in our application and show that field in the popup screen. But this unfortunately means it will open a new browser tab for each order.

4 replies

Forum|alt.badge.img+2

Hi Peter, I can of course not completely comprehend what your application looks like. But if in the screentype you would have both a pivot and a grid on the subject your pivot is based on.

Than those grid rows should reflect the cell the user has focused in the pivot.

So not a detail, because that would filter on the ‘parent’ keys and thus result in just 1 row, if that makes sense. But a grid on the view/table behind the pivot.

I have this example in a demo. And this is just a screentype with a pivot and grid on the ‘shoe_price’ subject. 

 


Forum|alt.badge.img+8
  • Author
  • Captain
  • 64 replies
  • November 7, 2025

Thanks, I have added the grid to the screen type and that shows all relevant rows. I also added the order detail next to it to zoom in.

There was still one problem though, the lowest level of my pivot grid is order-line (and I want to keep it that way). So the grid shows double orders for each line that is included in the aggregation. I solved this for now by not using a grid, but by using a treeview which uses the order as parent. 


Forum|alt.badge.img+8
  • Author
  • Captain
  • 64 replies
  • November 7, 2025

Still one problem: the treeview is shown as detail behind the pivot grid, every time when a user switches tab to the treeview and back to the pivot grid, the pivot grid is reloaded and all Categories will be collapsed again. This is very annoying and it makes the user lose track of where he/she was. Is there a way to stop this behaviour or is it a bug?

Edit: I tested with extended property AutoExpandGroups: Yes, but this seems to have no effect.


Forum|alt.badge.img+2

That does indeed sound like a bug. Could you please raise an issue and add a video of what exactly goes wrong?