Creating sub columns only for few columns in the pivote table

[#1]

Hello,

Is it possible to create sub columns only for some columns in the pivote table keeping other columns as it is?

If yes how to do that?

[#2]

Hello,

I think its possible by using mini chart.

for it Property->Expression->Display Option->Representation->mini chart

Hope it will help you

[SunilChauhan]

it may be done after draging one dimension to expression  pivot table

[#4]

hi Chanchal..

Thanks for replying.

But there is no such option in my Property->Expression->Display Option->Representation-> ???

I have also attached the snapshot of my pivote table properties.

[#5]

Hi Sunil,

What you said that I have already implemented.

But then it creates sub column for all the expressions.

But we need to create sub columns only for few expressions.

For e.g: On Expressions tabs we have 8 columns.

But we need sub columns only for 4 columns. The other columns should remain as it is.

The other 4 columns are the Consolidated columns.