Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding information to a Pivot Table
All,
I created a forecast pivot table that looks like: Project owner Client Project Rule name % Used Backlog Type Backlog Action Plan Progress Update Oct-2006 ($) Nov-2006 ($) Dec-2006 ($) Total January February March April Where I need to be able to make the January, February, March.........columns accept input on the pivot table. When an attempt is made to enter any data, the entire column assumes the same value as the input value in a single cell. Is there any way to allow separate data entry in each cell? Thank you for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding information to a Pivot Table
Hi Bill
Not exactly sure what you mean here. You cannot enter data directly onto a Pivot Table, you can only enter or amend data in the source data table which upon Refresh will be reflected in the PT itself. Post back with a bit more detail and maybe we can help you. -- Regards Roger Govier <Bill wrote in message ... All, I created a forecast pivot table that looks like: Project owner Client Project Rule name % Used Backlog Type Backlog Action Plan Progress Update Oct-2006 ($) Nov-2006 ($) Dec-2006 ($) Total January February March April Where I need to be able to make the January, February, March.........columns accept input on the pivot table. When an attempt is made to enter any data, the entire column assumes the same value as the input value in a single cell. Is there any way to allow separate data entry in each cell? Thank you for your assistance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding information to a Pivot Table - Forecast for Q1 2007B.xls (0/1)
Roger, Thanks for the reply. I have attached the spreadsheet. I am allowed to put entries in the Jan through Decr cells on the pivot table but any entry causes the entire column to assume the same value. I would like to know if I can enter discrete data in each cell. Thanks. On Sun, 31 Dec 2006 08:40:41 -0000, "Roger Govier" wrote: Hi Bill Not exactly sure what you mean here. You cannot enter data directly onto a Pivot Table, you can only enter or amend data in the source data table which upon Refresh will be reflected in the PT itself. Post back with a bit more detail and maybe we can help you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding information to a Pivot Table - Forecast for Q1 2007B.xls (0/1)
From my perspective, fortuitously you didn't post any attachment and should
not. You can send it directly to Roger if he is interested. Contact him and ask. -- Regards, Tom Ogilvy <B ill G wrote in message ... Roger, Thanks for the reply. I have attached the spreadsheet. I am allowed to put entries in the Jan through Decr cells on the pivot table but any entry causes the entire column to assume the same value. I would like to know if I can enter discrete data in each cell. Thanks. On Sun, 31 Dec 2006 08:40:41 -0000, "Roger Govier" wrote: Hi Bill Not exactly sure what you mean here. You cannot enter data directly onto a Pivot Table, you can only enter or amend data in the source data table which upon Refresh will be reflected in the PT itself. Post back with a bit more detail and maybe we can help you. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding information to a Pivot Table
All,
I didn't realize that we shouldn't attach files to this site. Anyway, here is an extraction from the spreadsheet: Assigned Team Client Project Project owner Revenue or Billing Rule name Rule description % Used Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Team A Test 1010 Test Invoice 1010 Test, Person 8 Revenue Rule 1010 Rule Description 1010 0 1 34 5676 787 88 4 6 78 34 56 23 56 2000 Test 1012 Test Invoice 1012 Test, Person 8 Revenue Rule 1012 Rule Description 1012 0 1 34 5676 787 88 4 6 78 34 56 23 56 1000 Test 1016 Test Invoice 1016 Test, Person 8 Revenue Rule 1016 Rule Description 1016 0 1 34 5676 787 88 4 6 78 34 56 23 56 2000 Test 1017 Test Invoice 1017 Test, Person 8 Revenue Rule 1017 Rule Description 1017 0 1 34 5676 787 88 4 6 78 34 56 23 56 2000 Test 1091 Test Invoice 1091 Test, Person 4 Revenue Rule 1091 Rule Description 1091 0 1 34 5676 787 88 4 6 78 34 56 23 56 500 Test 1105 Test Invoice 1105 Test, Person 4 Revenue Rule 1105 Rule Description 1105 0 1 34 5676 787 88 4 6 78 34 56 23 56 4000 The problem I am facing is that any entry that I make in a cell on the pivot table for Jan through Dec assumes the same value for the entire column. Is there a way to enter data in each cell (on the pivot table) from Jan through Dec and keep that data discrete to that cell so that I might use it for data entry? Thanks. On Sat, 30 Dec 2006 17:25:50 -0800, Bill wrote: All, I created a forecast pivot table that looks like: Project owner Client Project Rule name % Used Backlog Type Backlog Action Plan Progress Update Oct-2006 ($) Nov-2006 ($) Dec-2006 ($) Total January February March April Where I need to be able to make the January, February, March.........columns accept input on the pivot table. When an attempt is made to enter any data, the entire column assumes the same value as the input value in a single cell. Is there any way to allow separate data entry in each cell? Thank you for your assistance. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding information to a Pivot Table
Hi Bill
It's difficult to see the data in this form. If you want to mail me a copy of the sheet direct, I will take a look. Please remove NOSPAM from my email address to send. -- Regards Roger Govier <Bill G wrote in message ... All, I didn't realize that we shouldn't attach files to this site. Anyway, here is an extraction from the spreadsheet: Assigned Team Client Project Project owner Revenue or Billing Rule name Rule description % Used Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Team A Test 1010 Test Invoice 1010 Test, Person 8 Revenue Rule 1010 Rule Description 1010 0 1 34 5676 787 88 4 6 78 34 56 23 56 2000 Test 1012 Test Invoice 1012 Test, Person 8 Revenue Rule 1012 Rule Description 1012 0 1 34 5676 787 88 4 6 78 34 56 23 56 1000 Test 1016 Test Invoice 1016 Test, Person 8 Revenue Rule 1016 Rule Description 1016 0 1 34 5676 787 88 4 6 78 34 56 23 56 2000 Test 1017 Test Invoice 1017 Test, Person 8 Revenue Rule 1017 Rule Description 1017 0 1 34 5676 787 88 4 6 78 34 56 23 56 2000 Test 1091 Test Invoice 1091 Test, Person 4 Revenue Rule 1091 Rule Description 1091 0 1 34 5676 787 88 4 6 78 34 56 23 56 500 Test 1105 Test Invoice 1105 Test, Person 4 Revenue Rule 1105 Rule Description 1105 0 1 34 5676 787 88 4 6 78 34 56 23 56 4000 The problem I am facing is that any entry that I make in a cell on the pivot table for Jan through Dec assumes the same value for the entire column. Is there a way to enter data in each cell (on the pivot table) from Jan through Dec and keep that data discrete to that cell so that I might use it for data entry? Thanks. On Sat, 30 Dec 2006 17:25:50 -0800, Bill wrote: All, I created a forecast pivot table that looks like: Project owner Client Project Rule name % Used Backlog Type Backlog Action Plan Progress Update Oct-2006 ($) Nov-2006 ($) Dec-2006 ($) Total January February March April Where I need to be able to make the January, February, March.........columns accept input on the pivot table. When an attempt is made to enter any data, the entire column assumes the same value as the input value in a single cell. Is there any way to allow separate data entry in each cell? Thank you for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Information for Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
Using the information from a pivot table | Excel Worksheet Functions | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
getting information about a pivot table | Excel Programming |