Dynamic reports with PivotTables
PivotTables make it easy to create dynamic and visually engaging reports without writing a single formula. We will demonstrate this by creating a report like the one in Figure 5.29, using just a Pivot Table, slicers, and a PivotChart. A Pivot Chart is essentially a chart built on the outcome of a Pivot Table:
Figure 5.29 – A dynamic report created by using a Pivot Table
The practice file is Dynamic Reports.xlsx and can be accessed in the companion folder. The practice data is in the Sales Data sheet, as shown in Figure 5.30:
Figure 5.30 – The Pizza Inc sales data
The sales data, shown in Figure 5.30, is for a fictitious company called Pizza Inc that has five branches across Nigeria. They sell 16 different pizza types grouped into two categories. Pizzas priced at 4,000 naira and less are classed as regular, while pizzas selling at prices greater than 4,000 naira are classed as...
