When I add a calculated item in a pivot table ie a "variance" column to
calculate "Actual-Budget", a lot of lines pop up with empty values, I'm just
wondering if there's a way to get rid of the lines (in my case it's the
different accounts) that has zero values. I know I can pick and choose the
lines I want from the drop down list, but is there a functionality in pivot
table that can get rid of the empty value lines automatically?

Thanks...