As for the "(blank)" value in the row area, I don't think you can change
the value itself. But you can use conditional formatting to change the
font to white so that you can't see it. I usually use a macro for this,
but you can also do it manually.

Also, maybe you could create a column in the source data table that
uses a modified version of the formula you tried before ("=IF(Units=0,"
",Units)") -- just assign a value " " (space) rather than the
zero-length string. Then use this new column in the Row area rather than
the original Units column.

As for placing a value of "INCLUDED" in the data area, this can't be
done because the data area is strictly for numbers, not text. Below are
a few ideas for possible ways to get across the same information,
depending on whether the number was calculated from real data or from an
empty data set:

1) make a calculated field like you did, but rather than assigning a
value of "INCLUDED", assign a unique and recognizable numerical value
that will stand out and tell you the same thing;
2) use the "for empty cells, show" option in the Pivot Table Options
dialog box for whenever there is no data behind the calculation;
3) in the pivot table wizard layout, put the Price field in the data
area twice, once to sum and once to count. The count will tell you how
many times the row item appeared in the calculation (a count of zero
means an empty data set);
4) use conditional formatting (just like with the "(blank)" issue) to
make zero values (and/or blank values) stand out in the data area.

I hope this helps.


--
kbenda