Report Information
The Item Like-for-Like report lets you compare product sales at your site with past performance. For a selected date, see how sales measure up against the previous day, the same day last week, and a four-week average. Sales are grouped by Reporting Day Part, giving you a clear, structured view of trends. Use these insights to track performance and make informed business decisions.
Access the Item Like For Like report via: Reports & Analysis > Sales > Item Like For Like.
The output of the report can very depending on the selected report filter options.
If required, this report can be created as a Saved Report and set up to send out periodically.
Information on report filter options
The table below summarises report filter options available for this report.
| Report Date |
Select which date to report on, or select either [TODAY] or [YESTERDAY]. |
| Number Of Days Store Open In Last 4 Weeks |
Select how many days your store was open in the 4 weeks prior to the selected report date. The 4-week average is based on this value. By default this will populate with 28 assuming a 7-day week, but you can enter any value. (i.e. For a 6-day week enter: 24; for a 5-day week enter: 20) |
| Product Groups |
Select which product groups to include. If left blank, all groups will be included. |
| Data Type |
Select whether the values should be based on Net, Gross or based on sale quantity. |
| Group By |
Select whether to group products together in the report based on Group, Master Group, Super Group or have None. |
Report Output
The report provides insight into product sale quantities compared to historical data, split by reporting day parts, and separated into sections based on the Group By filter option selected.
Additional information on this view
The table below summarises the data shown in each column of this report view.
|
Product Name (PLU) |
Displays the name of the product, with its PLU shown in brackets. |
|
Day Part |
Displays the reporting day part name. (If configured for your site.) |
|
Date |
Displays the sales value based on the the selected Data Type. (i.e. Gross, net or quantity.) |
|
Day Before |
Displays the value but for the previous date. |
|
Week Before |
Displays the value for the same day in the previous week. |
|
4 Weeks Average |
Displays the average value over the previous four weeks. |
Percentage comparison indicators are also shown, where grey is a difference within +/- 5%; red is a difference less than -5%; green is a difference greater than 5%.
Comments
0 comments
Article is closed for comments.