 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Pivot Table Subtotal Question
I have a pivot table of prescription drug costs consisting of 4 columns: Month, Customer, Insurance and Base. [ Medicare D program - you're going to see a lot of this :-) ] Actually 2 questions: 1) Auto format gets me "January Total" for example, but no monthly totals or sub-totals. 2) Auto format seems to require something in Data Items. Other than the subtotal issue, column only format is really what I want. Presume these 2 issues are related. Appreciate any suggestions. Thx Dave A pivot table works by summarizing a field in the data area. If Insurance and Base are numbers, they should go in the data area. Then you could see a total per month or per customer. > I have a pivot table of prescription drug costs consisting of 4 columns: > Month, Customer, Insurance and Base. [ Medicare D program - you're going to [quoted text clipped - 8 lines] > > Presume these 2 issues are related. Appreciate any suggestions.  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Thank you Debra - that worked, I now have essentially three columns; Month, Data and Total. The Data column labels, vertically, are Sum of Customer, Sum of Base and Sum of Insurance. Third column is totals for each. All OK and the sums are correct. But - I need Customer/Base/Insurance strung out to the right from Month, as if each were a column head. Is there a way to do this??? Thx again Dave >A pivot table works by summarizing a field in the data area. If Insurance >and Base are numbers, they should go in the data area. Then you could see a [quoted text clipped - 12 lines] >> >> Presume these 2 issues are related. Appreciate any suggestions. You can rearrange the data fields so they appear horizontally: http://www.contextures.com/xlPivot02.html > Thank you Debra - that worked, > [quoted text clipped - 27 lines] >>> >>>Presume these 2 issues are related. Appreciate any suggestions. SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Fabulous - Thank you again Debra - one key stroke. Kind of embarrassing in a way, although not too intuitive ( at least to me.) Ditto the intuitive re: changing names (really Bill Gates.) LOVE your website - looks like I have quite a bit more to study. (Again, it's really embarrassing when you first question is answered in the first item. Ah well!) Thanks again - Best regards Dave Off and running - > You can rearrange the data fields so they appear horizontally: > [quoted text clipped - 35 lines] >>>> >>>>Presume these 2 issues are related. Appreciate any suggestions. You're welcome! And thanks for letting me know that you like my web site. > Fabulous - > [quoted text clipped - 51 lines] >>>>> >>>>>Presume these 2 issues are related. Appreciate any suggestions. SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html My pleasure ! Dave > You're welcome! And thanks for letting me know that you like my web site. > [quoted text clipped - 56 lines] >>>>>> >>>>>>Presume these 2 issues are related. Appreciate any suggestions. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.