How to show one column into 2 sub columns in pivot table ?

[tulasiram_bitra]

Hi Friends,

I would like to show one column into two sub columns in pivot table. How can i show , please help me to do this.

Please find the attached image to get better idea.

[Anonymous]

I am assuming PRG contains numeric values:

at script level you can define this subfield and then in Pivot table slicing feature you can show it:

Script level:

if(PRG>0 and PRG<=750,'<=750','>750') as PRG_Subfield

Hope this will help.

[tulasiram_bitra]

Hi ,

I have done in script level. Now I have 2 fileds like <=750 ton and >750 ton.

Now how can i show these like above image.

[Anonymous]

See the attachment.