ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   empty lines in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/132780-empty-lines-pivot-table.html)

Terri

empty lines in pivot table
 
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...


All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com