Added in wave 2 2022, if your organization wants to have multiple report layouts you can now choose which layout to use when the report is run. On the request page, users can use the dropdown menu to choose from available report layouts.
This feature will enable organizations to have multiple layouts, such as Excel layouts, for the same report dataset. For example, you could have a trial balance layout for a board meeting and one for distribution to departments.
For more information on this functionality – Choose the report layout on request page | Microsoft Learn