Page History

Standard report

Description:

Report allows to follow up meber and member sale statistics divided by member age and member gender.

Selections: 

• Date from - Default today
• Date to - Default today
• Retail store - Default all
• Loyalty program

Output:

Report is devided in 5 sections:

1. Graph and table showing number of members who joined in the selected date range, compared to the number of members who joined the year before.
2. Sales statistics divided between members and not member customers
3. Graph and table showing sales amount by gender and age groups
4. Sale statistics divided by member seniority level
5. Sale amount grouped per department, divided by gender

Columns: 

• Section 1
  • This year - number of members who joined in the selected date range,
  • Last year - number of members who joined the year before selected date range 
• Section 2
  • Num of receipts
  • Avg amount - (Sale amount inc. VAT)/(Num of receipts)
  • Items - number of items sold
  • Items/Cust - average number of sold items per customer
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 3
  • Age group
  • Sales inc. VAT
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 4
  • level - member characteristic
  • Num of receipts
  • Avg amount - (Sale amount inc. VAT)/(Num of receipts)
  • Items - number of items sold
  • Items/Cust - average number of sold items per customer
  • Gross profit
  • Gross profit % - Share of Gross profit in Sale amount
• Section 5
  • Department - Department name
  • Female - Sale amount inc. VAT for scpecific department generated by women
  • Female % - Share of sale amount inc. VAT for scpecific department generated by women in all sales inc. VAT across all departments and all genders
  • Total -Sale amount inc. VAT for scpecific department
  • Total % - Share of sale amount inc. VAT for scpecific department  in all sales inc. VAT across all departments

Sorting:

• Section 3 - Age group
• Section 4 - Level
• Section 5 - Department name

Clarifications:

• This year, las year - if date range is 2020/01/01 - 2022-/01/01, then This year is 2020/01/01 - 2022-/01/01 and Last year is 2019/01/01 - 2021/01/01

Source:

• Lindbak POS Reporting cube (OLAP)
• Lindbak POS Reporting DW