pivot tables, eliminating "0" values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My simple two column pivot table has a column showing dates and a sceond
column showing expense. Many of the dates have no expenses. How can I just
tabulate and total those dates with adjacent expense figures?
 
Build an Auto Filter on your Pivot Table and custom show all values
not equal to zero.

AQIB RIZVI
 
Thanks Aquib, although I think this means I have to populate the full year
long column before I define my pivot table. Please advise otherwise.
 
Tom
You do not need to populate the whole year, you can select the whole
column for your pivot table (with blank rows) and can uncheck the
'Blank' for Date in your pivot table.
Aqib Rizvi
 
Back
Top