Using a pivot table to report Actuals v Budget & show variance.
When the calculated field is inserted in the pivot it brings in rows into the pivot which are blank as well as those with data.
Any ideas how to only show rows with data?
Thanks to all for any suggestions.
When the calculated field is inserted in the pivot it brings in rows into the pivot which are blank as well as those with data.
Any ideas how to only show rows with data?
Thanks to all for any suggestions.