Group Pivot Data Based On Row Values In One Column

[mrmmickle1]

Rick,

First of all I must admit that I am not the best with Pivot Tables however, I have certainly used them on a number of occassions for OverTime Reports. Maybe I am missing something... I am not sure if this is quite what I am looking for. I have attached a file of a report that have created that has a similar final format for my needs, Except where Customers are at there would be Face, Core, Crossband, Core etc.... I have additional code to complete the rest of the formatting I am just having specific trouble with grouping.

Is this possible with the Pivot Table. Am I just not skilled at manipulating it? I apologize for my lack of expertise.

-Matt