Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can u share sample data?
That would be better for better silution
-Nagarjuna
Try it with right-click on those headers and then custom cell-format.
- Marcus
As Marcus mentioned enable the Designer Grid and right click to Custom Cell Format.See below
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
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
Hey Rehaan
You can right click on column name and check with the layout custom layer format.