Additional Reports using Pivot Table

Being able to analyze all your data can help you make better business decisions. Sometimes you may need a specific report that is not readily available on StoreHub. Once you have downloaded the raw data from your BackOffice, Pivot Tables are a great way to summarize, analyze, explore, and present your data. Both Microsoft Excel and Google Sheets have the ability to generate Pivot Tables.

Your pivot tables need to be generated from the transactions report. You can download the transactions report from Transactions > All Transactions. There are many useful guides online that show you how to generate Pivot Tables either using Microsoft Excel or Google Sheets.

Here are some examples of Pivot Table Reports that you may find useful:

Sales Trend Report

This report shows the sales of each variant of bread across a week. The 18th and 19th are the busiest days of the week, and Green Tea is clearly the most popular choice of variant.

Row : Item

Column : Date of Month (this was a new column created in the data file. It can be replaced by day, week, month etc)

Values : Quantity

Discount Report

This report shows how much discount was applied over three months.

Row : Month (this was a new column created in the data file. It can be replaced by day, week, month etc)

Values : Discount

Filter : Item - only select item rows that are blank. This is important, otherwise the discount value will be over-reported.