Pivot Table

[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

 

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

 

[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