Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ActiveSheet.PivotTables("cohortCLVTwoYear").CubeFields(17).EnableMultiplePageItems = _
- True
- ActiveSheet.PivotTables("cohortCLVTwoYear").PivotFields( _
- "[data1].[CUST_COMBINEDmonthsFromOrder].[CUST_COMBINEDmonthsFromOrder]"). _
- VisibleItemsList = Array( _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[01-03_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[04-06_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[07-09_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[10-12_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[13-18_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[19-24_Months]")
- ActiveSheet.PivotTables("cohortCLVTwoYear").CubeFields(17).EnableMultiplePageItems = _
- True
- ActiveSheet.PivotTables("cohortCLVTwoYear").PivotFields( _
- "[data1].[CUST_COMBINEDmonthsFromOrder].[CUST_COMBINEDmonthsFromOrder]"). _
- VisibleItemsList = Array( _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[01-03_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[04-06_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[07-09_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[10-12_Months]", _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[13-18_Months]")
- ActiveSheet.PivotTables("cohortCLVTwoYear").CubeFields(17).EnableMultiplePageItems = _
- True
- ActiveSheet.PivotTables("cohortCLVTwoYear").PivotFields( _
- "[data1].[CUST_COMBINEDmonthsFromOrder].[CUST_COMBINEDmonthsFromOrder]"). _
- VisibleItemsList = Array( _
- "[data1].[CUST_COMBINEDmonthsFromOrder].&[01-03_Months]")
Add Comment
Please, Sign In to add comment