ckcalvins
New member
- Joined
- Jun 22, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
So let's say I wanted to create a cubeset that represents two set expressions... For example, I want a cubeset of all countries in the set. Now, let's say I want the cubeset to represent all countries sorted by gross room nights for a specific dynamic period of time. The goal is to have cubesets that represent the past 7, 14, 21, 28 days so that I can easily see the top countries for each of the 7 day periods for quick week-over-week analysis. I cannot figure out how to get two set expressions into a single cubeset formula which can then be called in order via cuberankedmember. Once I have the ranked countries in order, I can easily input cubevalues to finish it up.
Maybe I'm going about this all wrong? I've watched tons of videos and some reference {} or FILTER, but I have been unsuccessful in figuring out how to get them to work within my data model.
Maybe I'm going about this all wrong? I've watched tons of videos and some reference {} or FILTER, but I have been unsuccessful in figuring out how to get them to work within my data model.