Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will see how to use images in PivotTable Report which is a new feature currently available to Beta Channel users of M365 as at the time of writing this blog post. Let’s get started
Sample Data and Loading to the Data Model
In the screenshot below, we’ve got a dataset that contains select list of countries, continent, flags, population, area, gdp and other columns
Create Pivot Table
- To create PivotTable Report, in the Tables group of the Insert tab, click on From Table/Range
- Place the PivotTable in the New or Existing Worksheets as desired
To see the countries flags in the pivot table report, we are going to use the flags field in the Report.
- In the PivotTable field, drag and drop Continent and Flags into the rows area
- Drag and Drop Population, Area and GDP into the Values areas
- In the Layout group of the Design tab, Select Show in Tabular Form from the Report Layout drop-down
From the screenshot below, we can see the image nicely displayed in the PivotTable Report
See you in the next tutorial