# Divide Item Sales Report

**URL:** <https://forum.sambapos.com/t/divide-item-sales-report/20788>\
**Category:** V5 Question\
**Created:** [September 18, 2019, 7:10am UTC](https://forum.sambapos.com/t/divide-item-sales-report/20788 "2019-09-18T07:10:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![anz\_at](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/c68b51/32.png) [@anz\_at](https://forum.sambapos.com/u/anz_at)\
**Post date:** [September 18, 2019, 7:10am UTC](https://forum.sambapos.com/t/divide-item-sales-report/20788/1 "2019-09-18T07:10:50Z")

</div>

I want to create two Item wise sales report.  
one Item wise sales report data should be less than the 4.30PM and other one data should be grater than the 4.30 Pm.  
Appreciate if some one can help me.

---

<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:** [September 18, 2019, 10:50am UTC](https://forum.sambapos.com/t/divide-item-sales-report/20788/2 "2019-09-18T10:50:23Z")

</div>

If you are up to date you should be able to add time to the end of date on the report dates fields at top…

---

<div class="post-metadata">

**Author:** ![anz\_at](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/c68b51/32.png) [@anz\_at](https://forum.sambapos.com/u/anz_at)\
**Post date:** [September 18, 2019, 12:02pm UTC](https://forum.sambapos.com/t/divide-item-sales-report/20788/3 "2019-09-18T12:02:16Z")

</div>

If we are hard code how we do this  
as a example

> {REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.Time \<4.30PM} like

---

<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:** [September 18, 2019, 1:13pm UTC](https://forum.sambapos.com/t/divide-item-sales-report/20788/4 "2019-09-18T13:13:28Z")

</div>

Search the forum, several similar themed topics.  
Check here for some similar ideas;

> [@Sales Per Hour Report](https://forum.sambapos.com/t/sales-per-hour-report/5443/18):
>
> Thats it, you can customize that one to do what you want it shows the gist of how to build the sql.

If its shift change looks like simplest way would be to tag reports and report using tags but expect using actual time is also possible but from experience dealing with times is always more complicated than it first sounds, usually simplicity is easiest so forget am/pm and always use 24hr.  
To do larger smaller it needs to be an intiger/number so no :, need plain format like HHmm.

---

<div class="post-metadata">

**Author:** ![anz\_at](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/a/c68b51/32.png) [@anz\_at](https://forum.sambapos.com/u/anz_at)\
**Post date:** [September 18, 2019, 1:34pm UTC](https://forum.sambapos.com/t/divide-item-sales-report/20788/5 "2019-09-18T13:34:48Z")

</div>

Ok Thanks. I will check this