• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    VBA - OLAP Cube Filter - Test if Items exist

    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()...
  2. J

    VBA - OLAP Cube Filter - Test if Items exist

    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 =...
Back
Top