Hi guys,

I have 2 dimensions:
location that has 2 level: branch, salesperson
time that has 4 levels: year, quarter, month, day

1 measure: sales

I am trying to do this:

With
Member measures.max_sales as 'Max(time.month.members, sales)'
Member measures.max_salesperson as '<a list of salesperson with Max(time.
month.members, sales)>'

select {measures.max_salesperson, measures.max_sales} on Axis(0)
{location.branch.members} on Axis(1)
from tSales

My problem is that I don't know how to get a list of salesperson with Max
(time.month.members, sales). I've tried using Topsum and Filter with no luck.

Any help is appreciated.
Thanks
Paul


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1