Getting Column Summary in the Rows Pivot

[edkryez]

Basically what I'm trying to do is instead of calculating the columns msq1,msq2.. bsq1,bs2... and after link the value to another Worksheet, what's the way to do this with Pivot Table report to get the results the same as shown in pic attached?pivot.gif

[Glenn Kennedy]

Please don't post a picture. It really doesn't help much. Can you upload a sample spreadsheet, containing NO sensitive information & a clear description of what the end result should look like?

[edkryez]

Please don't post a picture. It really doesn't help much. Can you upload a sample spreadsheet, containing NO sensitive information & a clear description of what the end result should look like?

Thnx Glen I will do that

[edkryez]

Please don't post a picture. It really doesn't help much. Can you upload a sample spreadsheet, containing NO sensitive information & a clear description of what the end result should look like?

Added Attachment