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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Cumulative formula for word table 0
calculating a remainder field 0
Multiple IF Statement in Word 5
SUM & OFFSET & PIVOT TABLE?? 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Dates In Excel 5
pivot table calculated field 1

Top