Hi, community.
I am implementing an aggregated view in Workshop using a Function-based Pivot Table.
My goal is to aggregate an Object Set that has been edited in a Scenario and display the result in a Pivot Table.
However, my current understanding is that Function-based Pivot Tables do not have a mechanism to directly read an Object Set from a Scenario.
Because of this, I am considering the following workaround:
- Create a struct array variable in a Function by loading an Object Set with Scenario edits applied
- Pass the resulting struct array as an argument to the Pivot Table function, and use it for aggregation and display
In practice, however, I am running into an issue:
when I attempt to apply a Scenario while loading the struct array in the Function, the Scenario edits are not reflected as expected.
(If the Scenario is not applied, the Function behaves correctly.)
This leads to the following questions:
①Are Scenarios not designed to be applied to struct array variables?
②If Scenarios cannot be applied to struct arrays, is there any supported way to use a Function-based Pivot Table to aggregate an Object Set with Scenario edits applied?
Any guidance on expected behavior, supported patterns, or recommended alternatives would be greatly appreciated.