Is your 2nd post answering your own question?

I always thought of a pivot table similiar to a Hierarchy Grid where like items are merged and/or collapsable.