Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Modules _ Crosstab With Multi Columns

Posted by: foxtrojan Aug 31 2019, 10:25 AM

How do you do a Cross-tab with multi-columns, like

Row Total Qty Total Amount Jan Feb Mar
Apples 10 $10.00 5 $5.00 3 $3.00 2 $2.00
Oranges 20 $20.00 10 $10.00 5 $5.00 5 $5.00

Posted by: GroverParkGeorge Aug 31 2019, 11:53 AM

See the enclosed sample.
 FruitSold.zip ( 22.75K ): 17

Posted by: foxtrojan Aug 31 2019, 12:43 PM

Thank you so much for your quick response. So sorry the program is in 2003 version. Appreciate if you can give me your demo in Access 2003.

Posted by: RJD Aug 31 2019, 05:53 PM

Hi: PMFJI, but I see you haven't gotten the A2003 version yet (looks like George is busy). So I thought I'd do that ...

HTH
Joe



 FruitSold_A2003.zip ( 18.96K ): 14
 

Posted by: foxtrojan Sep 4 2019, 02:28 PM

Thank you so much Joe. Yes, still using the 2003, but in the midst of migrating to Version 2019.

Posted by: RJD Sep 4 2019, 03:35 PM

thumbup.gif

Posted by: foxtrojan Sep 8 2019, 10:41 AM

Thanks you so much, the multi columns cross tab works perfectly. With that I can create standard Statistical Cross Tabs for those guys who do not know how to do pivoting in Excel.
Thanks again.

Posted by: MadPiet Sep 8 2019, 09:22 PM

Can't they use Pivot Tables?

Posted by: foxtrojan Sep 20 2019, 08:36 PM

Hi MadPiet, that's interesting. How you go about it? Appreciate very much if you have a working sample for me to follow.

Posted by: MadPiet Sep 20 2019, 10:05 PM

Fox,
If you're using 2007, I'm not totally sure. I haven't used it in forever.
Later versions of Excel will let you do pivots until you're blue in the face, but they're more suited for analyzing data than just cranking out a standard static crosstab. So it depends what your needs are. The catch is that PowerPivot (2010 and later) uses DAX. You can avoid it for simple stuff, but if you learn some of it, you can do some seriously awesome analyses.
If that's what you're after, check out chandoo's channel on YouTube. (he has a great intro lecture that's maybe 10 mins long). If you can get your hands on a copy of a newer version of Excel, check out Rob Collie's website, www.powerpivotpro.com - if you look at the Book stuff, there's a place to download the files. You can poke around in them and see what you can do. But that's if you need more analysis and less just reports.

Posted by: foxtrojan Oct 29 2019, 08:36 PM

Hi MadPiet
Thank so much for your feedback. I will look into it, cause I need to create Statistical Reports for Management. Thanks again