I would like for my pivot table to NOT show the data (in the data/column
area) that sums to a zero value. I know how to show zero values and I went
thru the same menu: right click, table options, uncheck for empty cells show
But that doesn't do anything since there is data there it just rolls up to
a zero amount. Does anyone know how to get these zero amounts to not show in
the data?

Any help would be greatly appreciated.