MDX - Create generic column buckets and pupolate them

Hi there,

I am new to MDX so please pardon me if I write something stupid.

I have following SSRS report layout which is using MDX that I need to change.

Item    Store    Sales Qty  

101       A            5

101       B             10

101       C             1

102       B             2

103       C             3

I need something like this:

Item      Bucket 1     Bucket 2   Bucket 3  

101       10               5              1

102       2

103       3

A couple of notes:

1. I need to move Sales from stores A, B, C to generic buckets bucket 1 , 2, 3 bucket 1 being highest qty and 3 being the lowest

2. I have maximum of 2 buckets. So I need to exclude the if I have more stores

Any help would be really appreciated.

Thanks,

Nick