Standard report 
Description: Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit, etc.) per selected hierarchy level (department,item area, etc.) Selections: - Date from: Default today
- Date to: Default today
- Store: Possible to select one store or all available; default all
- Profile: Multivalue; default all
- Department: Multivalue; default all
- Article area: Multivalue; default all
- Article group: Multivalue; default all
- Article subgroup: Multivalue; default all
- Article identifier: Possible to select Item ID or Model. Only name of column is changed - field is always Item ID
- Grouping: Selection of hierarchy level for which number of best items will be displayed. Possible selections: Department, Article area, Article group, Article sub group, Store; default Area.
- Count: 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
Output: Sale statistics for selected number of best or worst items per selected grouping (store or hierarchy level) sorted by selected sort measure with totals on higher levels (e.g. for grouping: article area there are totals for department and store, but for grouping: depratment there will be only total per store) Columns: - Dept.: Department number
- Area: Item area number
- Grp.: Item group number
- Srg.: Subgroup number
- EAN
- Model/ItemID: Article identifier (ItemID - see clarifications)
- Item name
- Quantity
- Amount: Sales amount inc. VAT
- Net cost
- Gross profit
- Gr. prof. %: Share of Gross profit in Net amount
Sorting: Clarifications: - Article identifier: Possible to select Item ID or Model. Only name of column is changed - field is always Item ID
- Totals for given level are always placed in the end of list of items belonging to given level.
Source: - Lindbak POS Reporting cube (OLAP)
- Lindbak POS Reporting DW
| 