Excel Reporting
 
Library Overview Reference Products Images Sales Stock Departments Formal Stocktake Restrictions Customer/Account Day Of Week Time Of Day Weather

Excel Department Pinboards

Sales

  • department.sales.revenue.period
    Sales Revenue for a department
  • department.sales.qty.period
    Total Quantity sold for a department during a period. This is sum of quantity regardless of units of measure
  • department.sales.linecount.period
    Number of salelines sold for a department during a period. This is the number of times it appears on a customer receipt, not the quantity sold
  • department.sales.revenue.notax.period
    Sales Revenue excluding taxes for a department

Arguments

ParameterNameNotesExamples
1Department IdRequired123
2Start DateOnly include sales after this date. 1-jan-2020
today-180
3End DateOnly include sales up to this date1-jan-2021
today-90
4Location
5
6Restrictionsteller=1245

Examples

FormulaOutputNotes
=pinboard("department.sales.revenue.period", 2, "1-jan-2021", "1-jan-2022", 4, , "teller=188")18253.45 Total revenue for department 2 sold in store 4 during 2021 by teller #188
Note, there is an empty paramter reserved for future use, as highlighted yellow