Pivot table - Accent style customization

[#1]

Dear community,

Could we customize pivot table to accent style as shown below?

Thanks and best regards,

Chanel

[Sokkorn]

Hi Ms. Chanel,

This can be done easily by using Straight Table with image below

By the way, we can achieve it in Pivot Table as well, but need more input. Let try

1. Add new Expressions: RowNo(TOTAL)

2. Select new expression -> Check on "Conditional" -> Type 1<>1 in difinition box

3. Goto "Presentation" tab -> Select expresion "RowNo(TOTAL)" -> Uncheck "Suppress Zero-Values"

4. Go back to "Expression" tab -> Expend expression by click on + sign -> Select "Background Color" -> Definition: If(Mod(RowNo(TOTAL),2)=0,RGB(214,233,239),RGB(255,255,255))

You need to apply "Background Color" for all expression and dimension.

Regards,

Sokkorn

[jagan · Accepted solution]

Hi,

Use this expression in Background color option of Expressions and Dimensions

=If(Mod(RowNo(TOTAL), 2) = 0, RGB(100,0,0))

Regards,

Jagan.

[#4]

Thanks so much, Jagan!!!

Here we go:

Best regards,

Chanel