# Pivot Table - group by joined dataset instead of primary dataset **URL:** \ **Category:** Ask the Community\ **Tags:** workshop\ **Created:** [September 21, 2026, 9:43am UTC](https://community.palantir.com/t/pivot-table-group-by-joined-dataset-instead-of-primary-dataset/7254 "2026-09-21T09:43:10Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![LJA](https://avatars.discourse-cdn.com/v4/letter/l/cab0a1/32.png) [@LJA](https://community.palantir.com/u/LJA)\ **Post date:** [September 21, 2026, 9:43am UTC](https://community.palantir.com/t/pivot-table-group-by-joined-dataset-instead-of-primary-dataset/7254/1 "2026-09-21T09:43:10Z")
I am trying to add a pivot table in Workshop using two joined object sets. The only fields available in **Group by** seems to only refer to the **primary object set**. So, if you have a pivot table built with: Dataset A (primary) Dataset B (joined) Is there any way, I can group by the joined dataset ? I would prefer to do this within Workshop instead of Contour / Quiver. Any suggestions, would be much appreciated. 😃 ---
**Author:** ![Phil-M](https://yyz1.discourse-cdn.com/palantir/user_avatar/community.palantir.com/phil-m/32/4134_2.png) [@Phil-M](https://community.palantir.com/u/Phil-M)\ **Post date:** [September 21, 2026, 7:55pm UTC](https://community.palantir.com/t/pivot-table-group-by-joined-dataset-instead-of-primary-dataset/7254/2 "2026-09-21T19:55:31Z")
Yes, you need to configure the desired properties from Object Type B via a derived property on Object Type A in your workshop module. As derived properties they are accessible in (some) widgets like filters, charts and pivot tables. Note: derived properties is still in beta. So functionalities are limited. In case you do not see the functionality it needs to be enabled for your enrollment. https://www.palantir.com/docs/foundry/workshop/derived-properties/