# Item sales report and departmental report on metric

**URL:** <https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271>\
**Category:** V5 Question\
**Created:** [May 28, 2021, 5:04am UTC](https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271 "2021-05-28T05:04:07Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Castech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/castech/32/38503_2.png) [@Castech](https://forum.sambapos.com/u/Castech)\
**Post date:** [May 28, 2021, 5:50am UTC](https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271/2 "2021-05-28T05:50:01Z")

</div>

It’s possible, you will have to create a ticket type for each department and filter report by Ticket Type.

Checkout this post

> [@Custom Report - How to ticket seperated Item Sales Report by Ticket Type?](https://forum.sambapos.com/t/custom-report-how-to-ticket-seperated-item-sales-report-by-ticket-type/8946/3):
>
> Grouping Item Sales report by ticket type might be a little tricky. This is the report you need. [Sales:5, 2, 2,1] @{TICKET TYPE LIST} @{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,} \>\>Ticket Type|| $1 \>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (TY=$1) and O.MenuItemName="$2"} {REPORT ORDER DETAILS:' '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (TY=$1) and O.MenuItemName="$2":2} T…

---

_[View the full topic](https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271)._