How to group by Calculated dimention?

[#1]

Dear All,

Recently I face a Problem...

I have some VIPs, when VipCode is a dimention, I can use count(distinct DocumentNumber) to calculate their shopping frequency on a Straight table

eg:

vipcode |  Shopping Freq.

a          |  2

b          |  2

c          |  4

d          |  5

e          |  6

f          |   0

Is there any approach to build another Straight table

group by the Shopping Frequency?

eg:

shopping freq.| no of Vip

0     |  1

2     |  2

4     |  1

5     |  1

6     |  1

I originally Thought it's only a memory demanding process(recursive)... but now it seems impossible...

Anyone can help?

Many Thanks!

[tresesco · Accepted solution]

May be like attached sample?

[jagan]

Hi,

Please find attached file for solution

Regards,

Jagan.