MS SQL Server OLAP - MIN QUESTION PLEASE HELP

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MIN QUESTION PLEASE HELP

Peter

2006-03-31, 3:31 am

Hi

I have to calculate the following logic.

[Customer], [Customer Team Type Id]
I have created a measure based on [Customer Team Type Id] called
[MEASURE].[Min Team Type Id]

Example of what I need

Cutomer TeamTypeId MinTeamTypeId
Cust1 1 1
Cust1 2 1
Cust1 3 1

Cust2 2 2
Cust2 3 2

Cust3 1 1
Cust3 3 1

Cust4 3 3

Cust5 2 2
Cust5 3 2

I am trying various combinations with the MIN and ROOT functions but to no
avail. Please provide me with a example of code.

Thanks
Peter

Sponsored Links