Hi
Thank you, i have been using this site for a long time, have usually found my answer myself, but i'm totally stumping my self
VBA
The whole vba is triggered by me manually, it loads the sheet from my downloads folder into excel as a datamodel, i have detailed the vba below.
jmitFileLoad()...
I have a filter on an OLAP Cube table in excel
ActiveSheet.PivotTables("cohortCLVTwoYear").CubeFields(17).EnableMultiplePageItems = _
True
ActiveSheet.PivotTables("cohortCLVTwoYear").PivotFields( _
"[data1].[CUST_COMBINEDmonthsFromOrder].[CUST_COMBINEDmonthsFromOrder]"). _
VisibleItemsList =...