Forum Discussion

NumeritasMartin's avatar
NumeritasMartin
Frequent Visitor
7 years ago

Cubeset with multiple Excel cell inputs

Good Afternoon All,   I hope the festive December month is treating you well.   I am trying to get my Cubeset to accept multiple Cell entries, I have got two working but can't find or figure out ...
Need Help
Tips and Tricks
NumeritasMartin's avatar
NumeritasMartin
Frequent Visitor
7 years ago

So by converting the a PIVOT table that I got the following which works unless the cell is Blank.

 

=CUBESET("ThisWorkbookDataModel","{[Department].[Department Group].&["&$F$4&"],[Department].[Department Group].&["&$F$5&"],[Department].[Department Group].&["&$F$6&"]}","(Multiple Items)")

This is a workable solution for me however I would like to have a error wrapper for blank cells.

 

Thanks