var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Ranking in MDX
I need to rank salespeople by their depletion cases for each product brand. It should look something like this:
Brand1 Brand2 Brand3 Brand4
salesperson1 1 3 2 1
salesperson2 2 1 3 3
salesperson3 3 2 1 2
Can somebody show me how to program this in MDX.
It seems that I can only get a ranking of one group and it does not cross join or rank each salesperson for each brand.