PIVOT TABLE ISSUE

[#1]

I have a Pivot table with 3 Dimensions. I am pivoting on the third dimension.  The issue is that I want to make the Header for the 3rd dimension Bold.  Its making some of them Bold and some dont  The same works fine in straight table.  

Please see attached

[nagarjuna_kotha]

Can u share sample data?

That would be better for better silution

-Nagarjuna

[marcus_sommer]

Try it with right-click on those headers and then custom cell-format.

- Marcus

[chaper]

As Marcus mentioned enable the Designer Grid and right click to Custom Cell Format.See below

   

[markodonovan]

Hi Rehan,

As an alternative you could make a change in the Dimensions tab of the pivot table.

Expand your dimension, edit the 'Text format' and set to  '<B>'.

Thanks

Mark

[chaper]

Hi Mark,

              'Text format' and set to  '<B>' doesn't work all the time as per my previous experiences.Sometimes it works on few columns or Rows only.It is not reliable all the time.Custom Format cell works great.I switched from <B> to custom format cell.

thanks,

chaiperi

[#7]

Hey Rehaan

You can right click on column name and check with the layout custom layer format.