Forum Discussion
Formula Cubeset values range with filter on secondary argument
Hello, I try to create a cubeset that selectes all "calendar ID" values if another criteria, site, in the same pivot table is a fixed value. Thus i want to filter the calendar ID's for a fixed sh...
Hi Steven10970
from the distance it's difficult to see if the formula is correct or not, because we do not know your datamodel / tables.
But just keep in mind, that the CUBESET function itself does not provide any visible results. In order to see all the individual members of the cubeset (e.g. calendar id's), you would need to use also the CUBERANKEDMEMBER and CUBEVALUE functions.
Let's assume you have your CUBESET function in cell A1. Then this will give the first member:
=CUBERANKEDMEMBER("ThisWorkbookDataModel";$A$1;1)