Pivot Table Calculated Field / Item

[Guest]

I have a Pivot Table structured as follows using the first Auto Format option.
I need to customize the items that get displayed in the Units Row Field
column and the Price Data Field Column. Specifically I need the "Units" Row
Field to actually be blank vs. "(blank)" when it's blank or 0 or ideally
dependent on another undisplayed Field's ("UnitType") value being "YN". I
also need the "Price" Data Field to show "INCLUDED" when its value is 0.

I tried creating a Calulated Field for Units with the formula
"=IF(Units=0,"",Units)", but when I tried to add it as a Row Field, it says
"The field you are moving cannot be placed in that PivotTable area". I tried
defining a Calulated Field for Price with the formula
"=IF(TotalPrice=0,"INCLUDED",TotalPrice )", but it shows "#VALUE!" vs.
"INCLUDED". Thanks!

Cat Sub Item Description Unit Name Units Price

Category A-23456789012345678901234567890
Subcagegory A-567890012345678901234567890
Item 1 1234567890 12345 $123456.12
Item 2 1234567890 12345 $123456.12
Subcagegory B-567890012345678901234567890
Item 1 1234567890 12345 $123456.12
Item 2 1234567890 12345 $123456.12

Category B-23456789012345678901234567890
Subcagegory A-567890012345678901234567890
Item 1 1234567890 12345 $123456.12
Item 2 1234567890 12345 $123456.12
Subcagegory B-567890012345678901234567890
Item 1 1234567890 12345 $123456.12
Item 2 1234567890 12345 $123456.12

 

[Guest]

'Anyone? Anyone?' If I should post to another group, please let me know.
Any help would be appreciated.

FYI, the relevant parts of the Source Table is as follows:

Category Subcategory ItemDescription UnitName UnitType Selected Units
TotalPrice
Category A Subcagegory A Item 1 SQ FT. NUM Y 100 1000.00
Category A Subcagegory A Item 2 SQ.FT. NUM Y 100 1000.00
Category A Subcagegory B Item 1 SQ.FT. NUM Y 100 1000.00
Category A Subcagegory B Item 2 SQ.FT. NUM Y 100 1000.00
Category B Subcagegory A Item 1 SQ.FT. NUM Y 100 1000.00
Category B Subcagegory A Item 2 SQ.FT. NUM Y 100 1000.00
Category B Subcagegory B Item 1 SQ.FT. NUM Y 100 1000.00
Category B Subcagegory B Item 2 SQ.FT. NUM Y 100 1000.00