Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
Could we customize pivot table to accent style as shown below?
Thanks and best regards,
Chanel
Hi,
Use this expression in Background color option of Expressions and Dimensions
=If(Mod(RowNo(TOTAL), 2) = 0, RGB(100,0,0))
Regards,
Jagan.
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
Hi,
Use this expression in Background color option of Expressions and Dimensions
=If(Mod(RowNo(TOTAL), 2) = 0, RGB(100,0,0))
Regards,
Jagan.
Thanks so much, Jagan!!!
Here we go:
Best regards,
Chanel