Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
In a pivot table is it possible to color the same as in the attached below. the upper side view is a dimention and left hand side is expression.
is it possible.
try to do by using custom format cell
Hi,
Use Custom Format Cell to change bkground color.
PFA result.
update:
Of course you should activate it in User Preferences Dialog.
Hope this helps.
Andrei
U should first change the chart type to straight table to format the cornor cell(Header of dimension). then change the type back to straight table. u wil have the same format as it was in straight table. just a trick![]()
-Sundar
Dear,
Kindly find the attachment .
I hope it will help u.
Thanks,
Mukram