ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Customize/ Hide data in pivot table (https://www.excelbanter.com/excel-programming/391279-customize-hide-data-pivot-table.html)

Angus

Customize/ Hide data in pivot table
 
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?


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com