You can use the highlight pivot table feature to show data in different pivot tables.

  1. Open the workbook editing page
  2. Click the Data Preview icon and select a dataset.
  3. Double-click or drag the fields to the panel, and then click Update.
  4. Click Highlight Pivot Table, and then select the area to show the data.
  5. Double-click or drag the fields to the panel, and then click Update.

You can modify the display name for different pivot tables.