Further Question about Pivot Tables - Multiple Consolidation Range

F

Florence

Dear all,

I've found an useful reference <http://www.contextures.com/xlPivot08.html>
from this Discussion Group. Have further question: The sample shows that
the column A has been defaulted in "Row" area and the rest of columns are all
in "Column" area in the PivotTable layout. Is it possible to change the
"Row" area say, calculate the unit price by "Colour" instead?

Thanks a lot!
 
Top