Hi I have a Excel formula for selecting items from a Slicer. But when I select more than what is in the formula 1-11 the result is #N/A.
I want my formulas to allow me to select Months and Display what has been selected or ALL when no selection has been made.
Same with selecting Models.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&" # of Transactions"&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,1)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,2)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,3)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,4)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,5)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,6)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,7)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,8)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,9)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,10)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,11)
I want my formulas to allow me to select Months and Display what has been selected or ALL when no selection has been made.
Same with selecting Models.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&" # of Transactions"&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,1)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,2)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,3)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,4)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,5)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,6)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,7)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,8)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,9)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,10)&", "&
CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer.SalesStatistics.SalesAppendMONTH,11)