Can you retain/enforce an initial sorting rule in one column regardless of the sort order in another for a grouped table?

[RyanPayso13]

I have a grouped table which has an initial sorting rule:

  const initialSortBy: Array<RisksIdentifiedSortBy> = [
    {
      id: DataAccessors.RISK_SCORE,
      desc: true,
    },
    {
      id: DataAccessors.GROUP,
      desc: false,
    },
  ];

The table itself is grouped by GROUP:

      <DataTable
        columns={columns}
        data={data}
        isLoading={false}
        isError={false}
        totalPages={1}
        initialGroupBy={[DataAccessors.GROUP]}
        initialSortBy={initialSortBy}
        isManualSortBy={false}
      />

I have enabled sorting by the RISK_SCORE column:

  {
    Header: (): JSX.Element => {
      return (
        <Box sx={{ margin: 'auto' }}>
          {t('policy-management/summary:TABLE.HDR.RISK_SCORE')}
        </Box>
      );
    },
    accessor: DataAccessors.RISK_SCORE,
    sortType: 'alphanumeric',
    Cell: ({
      value,
      row,
    }: DataTableCell<RiskLevel>): JSX.Element | null => {
      return !row.canExpand ? (
      ...
      ) : null;
    },
  },

But this recursively sorts the whole table by RISK_SCORE when I would like to retain/enforce/multi-sort on the GROUP column at all times without the column being sortable from the user's perspective.

      {
        Header: t('policy-management/summary:TABLE.HDR.RISK_GROUP'),
        accessor: DataAccessors.GROUP,
        Cell: ({ value }: DataTableCell<string>): string => value,
        SubCell: ({ row }: Pick<DataTableCell<any>, 'row'>): JSX.Element => {
          const {
            original: { riskCategory },
          } = row;
          return <Box sx={{ ml: '1.5rem' }}>{riskCategory}</Box>;
        },
        width: '20%',
        disableSortBy: true,
      },

Is this possible?

Or to put it another way is it possible to set the sort order of one column programmatically from another?

[RyanPayso13]

I managed to do this by using:

https://react-table.tanstack.com/docs/faq#how-can-i-manually-control-the-table-state

useControlledState and merging the sort order for Risk Grouping with any other manual sorting.

:)