Pivot Table

F

Faboboren

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
 
S

Shane Devenshire

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.
 
F

Faboboren

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table percentages 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Average of % in pivot table 1
Pivot table - Problem with % 5
Can i hide parts of a Pivot tables subtotals??? 2
Duplicating Pivot Tables 2
Can no longer format values in pivot table 4
Percentages of Subtotals for Pivot Tables 2

Top