Quick Newb MDX question

largeselection

Active Member
Joined
Aug 4, 2008
Messages
358
Hi,

I'm trying to create a named set via MDX, but I'm too new to accomplish what I'm trying to do (or even know if it's possible). Is it possible to create a topcount set based on multiple criteria?

So I know I can say Topcount(Salesman, 10, Sales) (forgive me for not using full structure), but can I do something more specific like Topcount(SalesMan, 10, {Sales,North America, 2010, Q1, Hybrids})?

So in the first example that says bring back top 10 salesman ranked by Sales. I would like to bring back top 10 salesman ranked by Sales that were also in North America, during Q1 of 2010, in the Hybrids category. So I can accomplish this via pivot table, by creating the topcount set and then just adding all of the rest of my criteria as filters that way the topcount set readjust based on what's filtered in the ptable, but that is quickly becoming messy.

If it were possible to do a topcount the way I'm envisioning it, then I could theoretically just use cubemember function and cuberankedmember functions to correspond so I could see the top 10 salesman by category all next to each other rather than multiple pivot tables all next to each other.

Thanks for any links, insight, thoughts.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top