Pivot tables in Workshop and Quiver on linked Object types

Replacing 125 financial P&L reports from SAP BW with Foundry. Workshop pivot tables don’t support linked Object types yet. PLTR plans to implement this month from now. As a workaround, we can create ONE Object Type in coderepo and use a pivot table. We prefer to work on the linked Object type. We created a transform table in Quiver with data from linked Object types. AIP suggested: Create a pivot table in Quiver and choose the transform table with the joined data as the Input Object Set. My issue: the Input Object set is only showing Object sets and not the transform table. Or if somebody has a better option, please let me know.

It’s going to be very hard to give you an answer without more specifics about the particular aggregation you want. For example: Object A is linked to Object B – we want to compute the average of Object B’s Property 1, grouped by Object A’s Property 2. Something like that…