To add the KPIs of Sales $ and Avg Discount % to the sheet, we have two options, as follows.
The first option is to add the KPI visualizations to the Master items library, and add them to the new sheet:
- Go to the dashboard sheet.
- Add the KPI visualizations of Sales $ and Avg Discount % to the Master item.
- Name them KPI Sales $ and KPI Avg Discount %, respectively.
- From the visualization section in the Master items library, simply drag and drop each of the KPIs into the top end of the sheet.
The second option is to copy and paste the KPI visualizations between sheets:
- Go to the dashboard sheet.
- Select the KPI visualization for Sales $.
- Press Ctrl + C or right-click on the visualization object and select Copy in the context menu.
- Go back to the Customer Analysis sheet.
- Press Ctrl + V or right-click in the empty area of the sheet and select Paste in the context menu.
- Repeat the same steps for KPI Avg Discount %.
Note that if the KPI visualization was created using chart suggestion, you will need to disable the chart suggestion switch to allow the visualization to be added to the Master items library.
The sheet editor will look like what's shown in the following screenshot:
