Hi
The attached file shows rows (eg those areas in yellow) where there is a row in the PT but there is no data for that row label in the Source Table.
How do I configure the Pivot Table so that I only get rows where there is at least one non-zero value on the row.
Thank You
Allister
Bookmarks