# Filtering a report

**URL:** <https://forum.sambapos.com/t/filtering-a-report/15094>\
**Category:** V5 Question\
**Created:** [June 11, 2017, 10:38pm UTC](https://forum.sambapos.com/t/filtering-a-report/15094 "2017-06-11T22:38:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkirk](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/d/439d5e/32.png) [@dkirk](https://forum.sambapos.com/u/dkirk)\
**Post date:** [June 11, 2017, 10:38pm UTC](https://forum.sambapos.com/t/filtering-a-report/15094/1 "2017-06-11T22:38:48Z")

</div>

In the workperiod report there is a section that groups by O.ItemGroup. How can I modify the report to list just certain groups. I would like to group all my taxable items in one report and untaxed items in another report. The report below gives me all groups.

[Group Sales by Amount:2, 1, 1]  
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True)}

> Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}

Any help would be appreciated. Thank you.

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [June 11, 2017, 10:57pm UTC](https://forum.sambapos.com/t/filtering-a-report/15094/2 "2017-06-11T22:57:39Z")

</div>

Not sure how personally, might be tricky as although tax is based on orders it is as far as I understand a ticket level detail.  
We can report the amount of tax on an order report, ie;  
{REPORT ORDER DETAILS:O.ExactTotal.Sum,TX.VAT:(ODI=True)}  
Replacing VAT with your tax name.  
But not sure how this can be aplied to only show taxable items.  
Obvously reporting tax amount with order group will show amount of tax but not sure on how you might achive a tax breakdown on this

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [June 12, 2017, 2:01pm UTC](https://forum.sambapos.com/t/filtering-a-report/15094/3 "2017-06-12T14:01:32Z")

</div>

Does this not work?

```auto
{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) && TX.VAT>0}

```

---

<div class="post-metadata">

**Author:** ![dkirk](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/d/439d5e/32.png) [@dkirk](https://forum.sambapos.com/u/dkirk)\
**Post date:** [June 16, 2017, 2:10pm UTC](https://forum.sambapos.com/t/filtering-a-report/15094/4 "2017-06-16T14:10:15Z")

</div>

That works and I figured out how to do what I needed. In Pennsylvania food is taxed by the restaurant but alcohol is taxed when it is purchased. I just divided up the Item Sales Report into 2 reports, one with taxed items and one with non-taxed items. Trying to save the bookkeeper a calculation.

Thank you for the reply.

---

<div class="post-metadata">

**Author:** ![somilmittal](https://forum.sambapos.com/user_avatar/forum.sambapos.com/somilmittal/32/33218_2.png) [@somilmittal](https://forum.sambapos.com/u/somilmittal)\
**Post date:** [June 16, 2017, 4:48pm UTC](https://forum.sambapos.com/t/filtering-a-report/15094/5 "2017-06-16T16:48:06Z")

</div>

Hi,

What does the flag ODI=True do? I do not see anything in the documentation on this.

Thanks,

---

<div class="post-metadata">

**Author:** ![sukasem](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/b38774/32.png) [@sukasem](https://forum.sambapos.com/u/sukasem)\
**Post date:** [June 16, 2017, 4:54pm UTC](https://forum.sambapos.com/t/filtering-a-report/15094/6 "2017-06-16T16:54:41Z")

</div>

> [@somilmittal](#):
>
> ODI

ODI = Order Decrease Inventory.  
In most case mean void orders