Pivot Table

[HemantC]

I am preparing a comparison sheet in which i am comparing values for 3 ids. For this, I am pulling data directly from the SQL database and making a pivot (external data query). For almost all the time, I would have ids (which are user input in excel) in the database, however, there can be a case where one of them might not be present.

I am using ids as a column field in pivot. So whenever there is no data for one of ids in the database, it disappears from the pivot but i want to see all of them in the pivot even if it shows no values for the id which was not present in dB.

Is there a way to achieve that. Can i deliberately enter a non-existent value in the pivot items of a column field?

Any help and suggestions on this is appreciated.

Thanks,
Hemant

[FDibbins]

To the best of my knowledge, a PT will only pull data that exists. So if a particular ID does not exist, then the PT will not pull it. If the info is in the database sometimes, why is it not there at other times?

I have a data link to access into excel, but that creates an actual data table in excel, and i base my PT's off that data