Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
exceluser
 
Posts: n/a
Default How to view summarized items in a pivot table

I created a pivot table for an aging report. It is broken down by not due,
0-30, 31-60, & 61+ days old by customer. When I double click in a cell say
31-60, I want to be able to see the items that make up that total. This is
bringing everything up on that customers account. What am I doing wrong?
Can I send my pivot table to someone to look at and help me?
Thank you
  #2   Report Post  
Knuth
 
Posts: n/a
Default



"exceluser" wrote:

I created a pivot table for an aging report. It is broken down by not due,
0-30, 31-60, & 61+ days old by customer. When I double click in a cell say
31-60, I want to be able to see the items that make up that total. This is
bringing everything up on that customers account. What am I doing wrong?
Can I send my pivot table to someone to look at and help me?
Thank you


Hello,

you can send it to:



I'll do my very best to help you.

Kind regards from Germany
Knuth
  #3   Report Post  
Deedles71
 
Posts: n/a
Default

I emailed today. Thanks

"Knuth" wrote:



"exceluser" wrote:

I created a pivot table for an aging report. It is broken down by not due,
0-30, 31-60, & 61+ days old by customer. When I double click in a cell say
31-60, I want to be able to see the items that make up that total. This is
bringing everything up on that customers account. What am I doing wrong?
Can I send my pivot table to someone to look at and help me?
Thank you


Hello,

you can send it to:



I'll do my very best to help you.

Kind regards from Germany
Knuth

Reply
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 Table unable to Include Hidden Items In Subtotals TC319 Excel Discussion (Misc queries) 1 March 21st 05 07:58 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. Jersey Girl Excel Discussion (Misc queries) 1 March 10th 05 04:20 AM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 01:01 AM


All times are GMT +1. The time now is 02:30 AM.

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"