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