Description: Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit) in two date intervals. Possible to select specifit hourly interval. Selections: - Date from - Default today
- Date to - Default today
- Compare date from - Default the same day of week as Date from year before
- Compare date to- Default the same day of week as Date to but year before
- Hour from - Default 0:00
- Hour to - Default 24:00
- Team - Default all
- Store - Default all
- Department - Default all
- Article area - Default all
- Article group - Default all
- Number of items - Number of best or worst items to display - default 10
- Sort type - worst or best - report will display given number of worst or best selling items - default best
- Sort measure - amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount
- Vendor - default all
- Subvendor- default all
- Include VAT - Default on
- Exclude groups - Default false
- Excluded groups - Appears when Exclude groups is switched to true
Output: Sale statistics for selected number of best or worst items per store sorted by selected sort measure devided in two selected date intervals in selected hour range. Columns: - Store
- Dept. - Department
- Area
- Grp. - Item group
- EAN
- Item name
- Quantity
- Turnover ex. VAT
- Gross profit
- Gross profit %
- Num of receipts
Sorting: Clarifications: - Hour selection applies to each day in selected date period
Source: - Lindbak POS Reporting cube (OLAP)
- Lindbak POS Reporting DW
| 