pivot table - sort items with different order for each parent item

[Bob Phillips]

That said the main reason is because my boss wants it like this.

The worst reason, but the most understandable .

I can't see anything in pivots that would facilitate this, the only way I could think is to have a calculated column in the original data that holds an index that gives the order that you want (something like

=IF(A2="P1",MATCH(B2,{"C1","C3","C2"},0),1))

, although that could get out of hand if you have lots of different types.