QB 2010 Pro Question

Help
I use QB 2010 pro and have a question about a report of "Sales Detail".
If I open "reports, sales, detail, and then enter a time period such as
one year, then I scroll to any certain item I sell, I see a great report that shows everything I want to see. Almost.
I see a Quantity column, an Amount column and a Balance column. All good so far.
The Amount and Balance columns have a total at the bottom of them which is important.
The Quantity column does NOT show a total, this is a serious pain for me. There must be a way to show this total of quantities sold but I can't figure it out.
Any solutions?
Thank you!!!
Wilby in Utah
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Export to excel and total it.
--
Paul Thomas, CPA
www.paulthomascpa.com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On 4/29/2013 9:56 AM, paulthomascpa wrote:

Hmmm... I guess that would work, If I can figure out how to export the report. I'll fiddle with this idea.
It really seems strange that QB can't provide a total. Oh well.
Thanks.
Wilby
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On 4/29/2013 9:56 AM, paulthomascpa wrote:

Hi Paul
I just gave your idea a try and it worked great. I see even more things I can do with the report in Excel.
Thanks
Wilby
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.