pivot table doesn't work

  • Thread starter Thread starter jrh
  • Start date Start date
J

jrh

i would like to use pivot tables to sum up data by sales
person and then copy into a formatted template. We have 4
types of sales and would like to do a pivot table for each
sales person but if a sales person doesn't have any of a
certain type of sale, the pivot table doesn't even list
that type of sale when summarizing that person's numbers.
How can you make a pivot table show all possibilities even
if a particular person doesn't have it. or should I be
using some other method?

thank you.
 
Double-click the grey field header.
Check "Show items with no data".
If there is no record in the main table make a blank one for th
person
 
Back
Top