# BAQ | Bucket Totals

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-10-18 17:04 UTC
**Views:** 990
**Replies:** 4
**URL:** https://www.epiusers.help/t/baq-bucket-totals/35842

---

## Post #1 by @tse.dba

I am trying to make multiple bucket qty shipped totals for each month for our parts.

Something like this:
**Partnum | JanShip | FebShip | MarchShip | ...**
**P-part    | 4,352     | 773        | 440,923     | ...**

Has anyone made something like this? If so, please share as to how.

Thanks!

---

## Post #2 by @josecgomez

Your profile says you are on version 6? is that right? This was put in Category for E10 so I am not sure... if you are in E10 then you can use a Pivot Query to do what you need.

---

## Post #3 by @tse.dba

Current live DB is 6. We are in the process of integrating to 10.1. I will check out the Pivot Query.

---

## Post #4 by @josecgomez

Here you go, this should get you there (BAQ Attached)
<img src="/uploads/default/original/1X/1f508b31b2673a788cd690e251081e88d30048e5.png" width="690" height="354">

<a class="attachment" href="/uploads/default/original/1X/ca2706e0494dda47d84aa909bd685f0c77b29ff7.baq">ShippedByMonth.baq</a> (26.8 KB)

---

## Post #5 by @bw2868bond

[Thumbs_Up_Sign.jpg]

<img src='/uploads/default/original/1X/b1280983fc92f619b6f4a4372110e41d31901686.jpg' width='182' height='192'>

---


**Canonical:** https://www.epiusers.help/t/baq-bucket-totals/35842
**Original content:** https://www.epiusers.help/t/baq-bucket-totals/35842