Pivot Table to include data not in main table.

[ojsevans]

Hello,

Say I am using Excel to track sales by a particular person, and then summarising this data in a pivot table, I would like the pivot table to also include salesmen who have thusfar made no sales that period. There would be a finite number of potential salesmen but they would not all be listed in the main table (from which the pivot is currently pulling it's data).

I would be able to list them in a separate worksheet but would not want to record zero value sales for them as this would look messy.

I have attached a worksheet which I hope might help.

Many thanks in advance for any help.

Kind regards,

Oliver

[dflak]

If you want a full report for a finite number of people who may or may not have data for them, it might be better to use an Excel Table and formulas like SUMIFS().

[peterrc]

What about adding a "Value of Sale" filter - see attached.
Would this work for you?

peterrc