hi,

my pivot table has a column called customer and in that drop down box there is a customer called "interplan" and it is ticked. yet the output sheet does not show it .

if i create another pivot table from the data it is in the drop down box and the output table

any idea what is wrong as i cannot afford for this to happen as the results are shown to others

thanks

steve