LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
les8
 
Posts: n/a
Default Sum vs. Count in Pivot Tables

Why, in pivot tables, do I sometimes get "sum" and other times
"count" when putting fields in the data section? I import data
from CSV files, and in one file I am trying to get the sum of
invoices (and I get count) while in another I am trying to get the
sum of purchase orders (and I get sum).

Thanks for any insights.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot tables and total count Pivot Table/Query Excel Worksheet Functions 1 September 12th 05 03:34 PM
Pivot tables Gus Excel Discussion (Misc queries) 1 August 31st 05 08:31 PM
Average of count in pivot tables Dan in NY Excel Worksheet Functions 0 August 17th 05 11:31 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM
Pivot Tables - "simple" question Eoin Bairead Excel Discussion (Misc queries) 1 February 28th 05 07:07 PM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"