I have a pivot table like a square matrix ( 20 * 20). On the grand total, I applied % of row total and came up with more zeros and 100's (Because of %). Now I copied it to a new sheet used conditional formatting to highlight values > 0.01 and those values are highlighted. Is there any possibility to eliminate cells that is not highlighted?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Eliminating zero values in Pivot Table
- Thread starter kr3geyn
- Start date
-
- Tags
- pivot 2010
Similar threads
- Question
- Question
