Hi - This is not happening. for e.g. in the Move Summary Pivot, if i have all "OK" and nothing as "Move Amount Mismatch", then the pivot shows with OK in the 'xlRowField' Field.
is it possible to keep just what i require in the pivot like "Move Amount Mismatch" rather than other items as False.?
Code:.PivotItems("OK").Visible = False .PivotItems("(blank)").Visible = False




Reply With Quote

Bookmarks