Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there any way to bring stripes in pivot table for a row? In style tab stripes every option is in disable.How can we bring stripes for rows.Can anyone pls help me out?
Regards
Krishna
Click on the + sign in front of the expression on the Expressions tab. Choose Background Color and enter an expression like =if(Even(RowNo(TOTAL)),rgb(230,230,230),white()). Do the same for the last dimension.
Hi Gysbert,
Thank you for your reply.I'm not getting the required one. The first row color is missing. I checked by using Odd property also, the color is applying for first two rows and alternate.I think the first row is considering as zero and the property is not working properly.Please find the attachment for the expected one and getting result.
Regards
Krishna
Looks like stripes to me. If you want the first odd rows colored instead of the even rows then change the expression to use the Odd() function or change the white() into another color.