# 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:** 6\
**Page:** 1

<div class="post-metadata">

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

</div>

Hi Samba great team.  
Is it possible to have item sales report as it is on the computer and departmental sales report? I purchased samba v5 and it’s working like charm in 4 departments, butchery, hotel, bar and rooms.

---

<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…

---

<div class="post-metadata">

**Author:** ![joshuakago](https://forum.sambapos.com/user_avatar/forum.sambapos.com/joshuakago/32/57769_2.png) [@joshuakago](https://forum.sambapos.com/u/joshuakago)\
**Post date:** [May 28, 2021, 8:56am UTC](https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271/3 "2021-05-28T08:56:13Z")

</div>

Thanks for the reply, please note am asking about the report on metrik.

---

<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, 8:58am UTC](https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271/4 "2021-05-28T08:58:07Z")

</div>

Ohh okay, wasn’t aware 🙂

---

<div class="post-metadata">

**Author:** ![muthoga](https://forum.sambapos.com/user_avatar/forum.sambapos.com/muthoga/32/18954_2.png) [@muthoga](https://forum.sambapos.com/u/muthoga)\
**Post date:** [May 29, 2021, 5:53am UTC](https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271/5 "2021-05-29T05:53:13Z")

</div>

how did you set your rooms,i will be interested. You can run a departmental report if you want to see the sales in each department

> [@Report By Specific ItemTag grouped by Department](https://forum.sambapos.com/t/report-by-specific-itemtag-grouped-by-department/12451/2):
>
> Hey vits One method is to feed the departments used into a @Parameter List and then pipe them into the {REPORT ORDER DETAILS:x} tag: @{REPORT TICKET DETAILS:T.Department,T.TotalAmount.sum::{0}:,} \>Dept: $1 {REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum:(DE=$1):{0}|${1}:} That above is user sales per department. I have not used tags much so no help there.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [May 29, 2021, 1:42pm UTC](https://forum.sambapos.com/t/item-sales-report-and-departmental-report-on-metric/24271/6 "2021-05-29T13:42:54Z")

</div>

> [@joshuakago](#):
>
> Thanks for the reply, please note am asking about the report on metrik.

Thank you for clarifying that. Please try to be specific with questions otherwise it’s impossible for us to provide useful help.

Metrik reports do not sync with the reports in SambaPOS. We will improve Metrik but no eta right now as we have several projects.