Formatting a Pivot Table

[#1]

I need to format a pivot table with every other row shaded and can't figure out how to do it.  Is it possible, and if so, how?

[#2]

This worked great!  Thank you!

[#3]

Since you were so helpful...

Maybe you can help me with one more question...in my pivot table, I need the second column that contains no information to be gone...when I try and use this object in an excel, it puts in the blank column and does not look proper.  Do you know how to get rid of this column in a pivot table?  Thank you!!!

[Siva_Sankar]

Hi Alissa,

Is the column heading you are trying to remove a Dimension or an Expression?

If it is an expression then there is no way to remove that in a Pivot table.  There is a show hide radio button for a straight table, but not on a Pivot.  

If it is a dimension at the top of the column, making sure you have Suppress Zero Values ticked on the Presentation tab is key.

Make sure that all values are actually zero - rather than a very small number that rounds to zero.  You could alter your expression to make values that are zero (or very near) null.  You will need to use an if statement to either show the result or null based on the value.

information from Steve Dark

[sunny_talwar]

I guess you already got what you needed now

Best,

S