Hans,

Insert another column into your data table, with a formula like

=AND(x<"",y<"")

like

=AND(C2<"",D2<"")

(Copied down to match your table)

The formula will return FALSE if either cell is blank, and TRUE only if both are non-blank.

Then use that column as either a page or row field for your pivot table.

HTH,
Bernie
MS Excel MVP


"Hans" wrote in message
...
Excel 2003
Hope somebody can help with the following. I have information x and y in the
same column concerning A (persons)in a pivot table. I would like to show
information x and y per person only if x and y both have a value. If x or y
doesn't have a value then the person in question should not be shown in the
report. I am not sure if pivot table is the best tool for this, but I do not
know of any other better tool. Ideas?