Pivot Problem

L

Lambi000

I have a query that, essentially, is a bill of material. I am attempting to
create a pivot table form that shows each level of the bill from 0 through 5.
When I place level three in the row, it shows (Blank) and (NonBlank) instead
of data.

Admittedly, at level three there are plenty of blanks, but why would the
non-blanks show the data (part number) instead of saying NonBlank? I can
look at the underlying query and see that the data is there, so what am I
doing wrong?

Thanks.
 
Top