Sub columns in pivote table

[#1]

Hello,

I want to create sub colums in Pivot table.

I know we need to drag 1 dimension over the expressions and create the subcolumns for all the columns in expressions.

But I dont want in this way.

I have 5 columns, out of which for 2 columns i need 1 sub column and for other 2 columns diff sub column and 1 column without any sub column.

I would like to know is it possible? If yes how? and if not any work around for the same?

Below is the format I need.

[#2]

Hi apurvapetkar,

Did you forget to add the example layout that you want.  Might be able to help if I can see what you're trying to achieve.

Mike.

[#3]

sorry missed the image.

Please check the attached image.