Hi,

Is there a way to create a pivot table which has rows/column selection
values which are not included in the base data?
I have dynamic base data, each row consisting of ProjectName , ProcedureName
and %compliance. The ProjectsNames are selected from a dropdown list of 10
possible projects.

I have created a pivotTable from the base data, with projectName on the
y-axis and ProcedureName on the x-axis, and %compliance in the middle.

If I only have rows of base data with say 5 of the possible 10 ProjectNames,
on the pivotTable i only then have the option of choosing between these 5
projectNames to display. Is it possible to include all 10 of the ProjectNames
in the selection in the pivotTable? Even when they are not all in the base
data? so if I picked one without any base data it would just show blank
%compliance info?

thanks very much for any help

cheers
Barbara