Display additional fields in a Pivot Grid

[ChuckHixon]

I have a working pivot grid. However, I would like to have 2 additional fields displayed in the pivot grid. They are numeric fields that are in the data source, but have already been aggregated outside of the data source. So all Ii want to do is display the content of these fields in the pivot grid. They appear in the list of fields in the data source, but the only option available to me is to aggregate the fields. I just want them to appear in the pivot grid as is. Is there a way to do this?

[Johnny Major]

Can you please share a screenshot of the columns section of your pivot grid config where you say the only option is to aggregate?

Here is an example of what I'm looking for:
Screen Shot 2022-01-24 at 9.54.11 AM.png

Thanks

[ChuckHixon]

​​​​​​The 2 quantity fields that are in the red box. I would just want them to display in the pivot grid as is. I don't want them as part of the aggregation or as a left or top axis. Is there a way to do this?

[Johnny Major]

No, the pivot grid columns can either be Left/Top or Aggregate