Ronson's Blog
  • Home
  • Shuttlecock Game Log
Subscribe
Tagged

VBA

A collection of 1 post

Excel

Filter out an Item from a Pivot Table using VBA with an OLAP Data Source

The following VBA code does not work as expected: PivotField.HiddenItemsList Property (Excel) Sub UseHiddenItemsList() ActiveSheet.PivotTables(1).PivotFields(1).HiddenItemsList = _ Array("[Product].[All Products].[Food]", _ "[Product].[All Products].[Drink]") End Sub To properly use this you must use the CubeField Object and also set the

Ronson Chan Jul 13, 2016 • 1 min read
Ronson's Blog © 2021
Powered by Ghost