Pivot heading format

[#1]

Hi All,

I have created pivot table which has 2 dimension Product, Month & expression is Sum(Sales).

I have dragged month horizontally for column level. Now Product aligned vertically and month horizontally.

I want to change background color on Month.

Do we have that kind of option? I could not find it

Thanks in adv

[prat1507 · Accepted solution]

Yes you can change the background color using this:

[#3]

Thanks,

I did not know this option. Moreover I have concat 2 formulas ( WeekDay(ReportDate) & ' - '& Day(ReportDate)). It looks now Mon-12. I want to wrap this like following ouput. Do we have any option for this?

Mon

12

I tried '\n' but doesn't works.

Thanks again

[prat1507]

Yes Narendra. You can use it as WeekDay(ReportDate) & chr(13)& Day(ReportDate)

Regards

Pratyush

[#5]

Thank you Pratyush... very helpful!!