Customize/ Hide data in pivot table

A

Angus

I have a pivot table in following layout:

Status(firm order/ forecast) (column field)
firm order (column) Forecast order
(column)
Product (row field) Sum of QTY Sum of Order Sum of QTY Sum of Order
(data)

I want to show per product, the sum of qty and sum of order for firm order;
and sum of qty BUT NOT sum of order for forecast order (as all of them are
zero).

How to make it? or any code I can use?
 
Top