The feature is released on current channel while you are using Monthly enterprise channel. If you want to use groupby and pivotby functions, you may contact your IT to switch your update channel to current channel.
Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Learn