Further Question about Pivot Tables - Multiple Consolidation Range
 

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!