![]() |
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