# Report By Specific ItemTag grouped by Department

**URL:** <https://forum.sambapos.com/t/report-by-specific-itemtag-grouped-by-department/12451>\
**Category:** V5 Question\
**Created:** [September 13, 2016, 4:52am UTC](https://forum.sambapos.com/t/report-by-specific-itemtag-grouped-by-department/12451 "2016-09-13T04:52:48Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pauln](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pauln/32/12698_2.png) [@pauln](https://forum.sambapos.com/u/pauln)\
**Post date:** [September 13, 2016, 8:43am UTC](https://forum.sambapos.com/t/report-by-specific-itemtag-grouped-by-department/12451/2 "2016-09-13T08:43:23Z")

</div>

> [@vits](#):
>
> That gives me the total as expected, but how would I go about having subtotals for each department

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.

---

_[View the full topic](https://forum.sambapos.com/t/report-by-specific-itemtag-grouped-by-department/12451)._