![]() |
|
![]() | ||
|
Subject:
Pivot Table Drill Down details
Category: Computers Asked by: letmebefrank-ga List Price: $2.50 |
Posted:
02 Dec 2005 05:32 PST
Expires: 01 Jan 2006 05:32 PST Question ID: 600476 |
I have created a Pivot Table in Excel that lists accounts in the row field and contains AR 30, 60, and 90 day balances in the data column. When double clicking to drill down to specifics the table pulls all AR balances for the account. I would like to drill down to the specific AR30, 60, or 90 day balances for that account. Is there a way to specify drill down data so that only the information in the particular AR subcatagory selected is displayed for an individual account? |
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
Subject:
Re: Pivot Table Drill Down details
From: manuka-ga on 05 Dec 2005 00:53 PST |
I'm not sure why you're experiencing this problem, but I suspect that you may have defined things so that AR30 and AR60 include the higher categories also. (I didn't get this problem with a quick trial using a code to specify each item as AR30/AR60/AR90.) In this case if you drill down on AR30 you'll get all the AR amounts, because that's how you've defined it. If you could post a link to an Excel file displaying this problem we can probably give you some more detailed help. |
Subject:
Re: Pivot Table Drill Down details
From: manuka-ga on 08 Dec 2005 00:24 PST |
Any progress? Can you post a file with this problem? |
Subject:
Re: Pivot Table Drill Down details
From: reined-ga on 08 Dec 2005 10:40 PST |
Put the AR 30, 60, and 90 day balances as "PAGE" not "column" and select the one you want to see |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |