Pivot Table - How to hide all rows which is 0

First enter this small macro:

Sub Macro1()
Dim r As Range
For Each r In Selection
If r.Value = 0 Then
r.EntireRow.Hidden = True
End If
Next

Then, in the pivot table, go to the column that may contain zeros and select
the cells you want to check.

Then run the macro
--
Gary''s Student


"Ctech" wrote:

>
> Hi guys
>
>
> I've made a massive pivot table.. however i want all rows which is 0 in
> one column to be hidden. Is there a setting for this, or do I have to
> make a macro to go and hide all rows which has 0 in a certain column ?
>
>
> Thansk
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=538405
>
>