# Crosstab BAQ - is it possible to create? **Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5) **Created:** 2016-11-30 21:51 UTC **Views:** 2435 **Replies:** 6 **URL:** https://www.epiusers.help/t/crosstab-baq-is-it-possible-to-create/36482 --- ## Post #1 by @miket91326 Hi, we are on E10.1.400.14 version. I am wondering if it is possible to create crosstab BAQs and Dashboards in Epicor? --- ## Post #2 by @Mark_Wonsil In Help, search for Pivot and check out the topic: “Aggregate Data Using Pivot” Mark W. --- ## Post #3 by @miket91326 Thanks Mark, this helped. MIKE TONOYAN | Application Maintenance MTonoyan@NatelEMS.com Tel +1.818.734.6511 | Cell +1.818.397.8515 --- ## Post #4 by @miket91326 Mark, do you know if it's possible to define dynamic column headings instead of having a constant fields? In my case I would like to have dates for every Monday of every week of the year as column headers with forecast and order release quantities. --- ## Post #5 by @LarsonSolutions Mark, Pointing to help worked really well. The example was simple - looking forward to leveraging this in other areas. Instead of counting the sales orders, could sum the amount of the sales orders or shipments. Bruce Larson Principal Consultant Larson Solutions 763-486-0030 | Bruce@LarsonSolutions.com --- ## Post #6 by @Mark_Wonsil I don’t think so, not in BAQ. However, if you feel comfortable to T-SQL, I would take Jeff Brus’s advice (from the EUG forum) and look at an External BAQ. You can leverage the power of stored procedures which allows you to do this kind of thing. Mark W. --- ## Post #7 by @miket91326 Thanks again, I was afraid I had to do that. --- **Canonical:** https://www.epiusers.help/t/crosstab-baq-is-it-possible-to-create/36482 **Original content:** https://www.epiusers.help/t/crosstab-baq-is-it-possible-to-create/36482