How to configure default row grouping when pivot mode is active?

[bhouse044]

Hello,

I am having difficulty configuring a default row grouping when pivot mode is active. When the page/app loads I would like a certain set of rows to be checked in the Columns > Row Group sidebar. What type of R configuration data structure is required to make this configuration work? I've tried a number of data structure formats and none seem to work. For example:

columnDefs = data.frame(
  c(headerName='Price', field='price', pivot=TRUE, rowGroup=TRUE, enableRowGroup=TRUE),
  c(headerName='Quantity', field='quantity', pivot=TRUE, rowGroup=TRUE, enableRowGroup=TRUE)
)

RagGrid::aggrid(
  data,
  colOpts = list(),
  options = list(emablePivot=TRUE, pivotMode=TRUE, columnDefs=columnDefs),
  formattingOptions = list(Price='$0,0.00', Quantity: '$0,0.00')
)

Ideally when the table loads I would like Price and Quantity to both be enabled as Row Groups.

Can you please suggest an alternative data structure to get this working (assuming that's the issue at hand)?

Thank you very much!