Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Pivot Table Column if Total Sum is Zero
Hello All,
I'm having a bit of difficulty trying to get this to work. Could someone provide an example or advice? I've seen a couple similar topics but I can't seem to get anything to work. My pivot table is structured as: one column field, "Code" with values of X,Y,Z two data fields, "Pcs" and "Ordered Pcs" one calculated field "Pcs minus Ordered Pcs" one row with Company Name So it looks something like: Code X Y Z Company A Pcs 10 15 20 Ordered Pcs 5 0 6 Pcs minus Ordered Pcs 5 15 14 Company B Pcs 12 10 10 Ordered Pcs 6 0 5 Pcs minus Ordered Pcs 6 10 5 Total Pcs 22 25 30 Total Ordered Pcs 11 0 11 Total Pcs minus Ordered Pcs 11 25 19 What I would like to do using VBA is to hide the column if "Total Ordered Pcs" = 0. So, in this example, it would be column "Y". How can I do this? Thanks...and I love these groups! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I sub-total 2 of 4items in a column in a pivot table? | Excel Discussion (Misc queries) | |||
Total Column in Pivot Table | Excel Discussion (Misc queries) | |||
Sub-Total Column in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Hide Total Row without hidding corresponding row | Excel Discussion (Misc queries) | |||
PIVOT TABLE - GRAND TOTAL COLUMN | New Users to Excel |