ability to auto file column(s) on a pivot table

G

Guest

repeating information is hiden on a pivot table, I would like the ability to
see a summation of this data without having to copy the pivot table as a
value & filling in the repeating data.

* you loose the functionality of the pivot table
* it becomes very time consuming with large pivot tables

current view:

Order ID Product Total
10248 Mozzarella di Giovanni 5
Queso Cabrales 12
Singaporean Hokkien Fried Mee 10



would like ablitity to view:

Order ID Product Total
10248 Mozzarella di Giovanni 5
10248 Queso Cabrales 12
10248 Singaporean Hokkien Fried Mee 10
 
D

Dave Peterson

Maybe you could have a macro that copies your pivottable to another location,
then converts to values, then fills in the cells.

Lots of my pivottables are only pivottables for a bit--just waiting to be
converted to values.
 

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

Add Custom Counter to a Query 3
Filter Totals in a Pivot table? 2
URGENT PLEASE! Filtering a Pivot Table further 4
i have a pivot table that I had to paste special and want to sum a 1
Calculating total amount in a Pivot Table 1
Pivot Table - how to add column on the same row 1
Copying values from pivot table to cells outside pivot table 4
How to add a percentage column in a Pivot Table 1

Top