Excel Department Pinboards

• 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

Parameter	Name	Notes	Examples
1	Department Id	Required	123
2	Start Date	Only include sales after this date.	1-jan-2020 today-180
3	End Date	Only include sales up to this date	1-jan-2021 today-90
4	Location
5
6	Restrictions		teller=1245

Examples

Formula	Output	Notes
=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