daily pastebin goal
60%
SHARE
TWEET

Untitled

a guest Dec 7th, 2017 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ActiveSheet.PivotTables("cohortCLVTwoYear").CubeFields(17).EnableMultiplePageItems = _
  2.     True
  3. ActiveSheet.PivotTables("cohortCLVTwoYear").PivotFields( _
  4.     "[data1].[CUST_COMBINEDmonthsFromOrder].[CUST_COMBINEDmonthsFromOrder]"). _
  5.     VisibleItemsList = Array( _
  6.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[01-03_Months]", _
  7.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[04-06_Months]", _
  8.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[07-09_Months]", _
  9.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[10-12_Months]", _
  10.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[13-18_Months]", _
  11.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[19-24_Months]")
  12.    
  13. ActiveSheet.PivotTables("cohortCLVTwoYear").CubeFields(17).EnableMultiplePageItems = _
  14.     True
  15. ActiveSheet.PivotTables("cohortCLVTwoYear").PivotFields( _
  16.     "[data1].[CUST_COMBINEDmonthsFromOrder].[CUST_COMBINEDmonthsFromOrder]"). _
  17.     VisibleItemsList = Array( _
  18.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[01-03_Months]", _
  19.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[04-06_Months]", _
  20.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[07-09_Months]", _
  21.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[10-12_Months]", _
  22.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[13-18_Months]")
  23.    
  24. ActiveSheet.PivotTables("cohortCLVTwoYear").CubeFields(17).EnableMultiplePageItems = _
  25.     True
  26. ActiveSheet.PivotTables("cohortCLVTwoYear").PivotFields( _
  27.     "[data1].[CUST_COMBINEDmonthsFromOrder].[CUST_COMBINEDmonthsFromOrder]"). _
  28.     VisibleItemsList = Array( _
  29.     "[data1].[CUST_COMBINEDmonthsFromOrder].&[01-03_Months]")
RAW Paste Data
Top