I am going to have to look more into the buckets stuff. I did look at Discretizationmethod in the cube dimensions but couldn't get it to do what I want.

Does...

Thanks Ells. I have done this and it works a treat:

I created a view bringing in supplier and customer and ranked the customer partitioned by supplier and created groups of...

Thanks Ells. Any guidance is very welcome.

How do you move a calculated member to a table in the datasourceview?

Using the calculations tab I have tried adding it (calculated member: rankGroup)...