![]() |
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