G
Guest
I'm creating a budget pivot table. Its' source is a worksheet in the same
workbook that is linked to individual department budget workbooks. A general
budget template was used for all departments and many of the accounts have a
zero value in the amount column. The pivot table picks up all the accounts,
including the ones with zero values. Is there any way to suppress these lines
without actually deleting the linked rows? I'd like to keep the pivot table's
workbook flexible and generic but it prints an excessive amount of rows with
no numeric values.
Thanks,
TomD
workbook that is linked to individual department budget workbooks. A general
budget template was used for all departments and many of the accounts have a
zero value in the amount column. The pivot table picks up all the accounts,
including the ones with zero values. Is there any way to suppress these lines
without actually deleting the linked rows? I'd like to keep the pivot table's
workbook flexible and generic but it prints an excessive amount of rows with
no numeric values.
Thanks,
TomD