pivot table auto group by dimension

[#1]

How can i make a auto group by from dimensions in a pivot table.

My dimension has more than 10000 values and i wanna put them in groups.

<1000

1000-1099

1100-1199

enz

Is that possible and how?

greetz,

dirk groen

[#2]

Hi,

Maybe you can use the function CLASS in your script load, and create a new field if the group that you want.

[johnw · Accepted solution]

Perhaps this. The dual() function keeps them sorted in numeric order.

if(MyField<1000,dual('<1000',1)
,dual(floor(MyField,100)&'-'&(floor(MyField,100)+99),floor(MyField,100))) as MyNewfield

[#4]

Thanks a lot. He works fine

Greetz,

Dirk Groen