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 specific 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
| 