Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
Hi,
I have a database in Access, and then I have created a Pivot Table in Access...... In Access I can get original numbers under Sum of Linear (I am adding before numbers to get to this point) or with function show as percent of parent row item percentages within the Banner... But then I want to publish that in Excel, and I am getting back my original numbers instead of percentages.. Any way to keep percentages in Excel pivot table and keep link to Access Pivot Table.. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
Hi,
I have never tried linking the Access PT to an Excel PT, but generally I would build a pivot table in Excel which is connected to the Access table or query. Then you get all of Excel's pivot options but are able to directly refresh the Access data. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Faboboren" wrote: Hi, I have a database in Access, and then I have created a Pivot Table in Access...... In Access I can get original numbers under Sum of Linear (I am adding before numbers to get to this point) or with function show as percent of parent row item percentages within the Banner... But then I want to publish that in Excel, and I am getting back my original numbers instead of percentages.. Any way to keep percentages in Excel pivot table and keep link to Access Pivot Table.. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
Thanks
My Pivot Table is in Excel connected to Acces Pivot Table... but in Access Pivot Tables I can show percentages as percent of parent row item, but in Excel linked Table shows only original numbers or total percentages... I need to show percentages in Excel Table Table within Subtotals "Shane Devenshire" wrote: Hi, I have never tried linking the Access PT to an Excel PT, but generally I would build a pivot table in Excel which is connected to the Access table or query. Then you get all of Excel's pivot options but are able to directly refresh the Access data. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Faboboren" wrote: Hi, I have a database in Access, and then I have created a Pivot Table in Access...... In Access I can get original numbers under Sum of Linear (I am adding before numbers to get to this point) or with function show as percent of parent row item percentages within the Banner... But then I want to publish that in Excel, and I am getting back my original numbers instead of percentages.. Any way to keep percentages in Excel pivot table and keep link to Access Pivot Table.. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) |