Range for amount

[#1]

In one of my table it has Depreciation amount and ID and 20fields how to make range of data. In this table more than 150 ID need range 0-10,10-20,20-30.

ID, Dep Amount

1	9658
2	9856
3	9845
4	9874
5	9854
6	9852
7	9632
8	9541
9	9745
10	3698

Thanks

[its_anandrjs]

Hi,

You have to create the calculated dimension and use the Class function in and straight chart or pivot chart

=Class(ID,10)

Regards

Anand

[#3]

But it give symbols in the axis with range  '<= x <' any reasons why.

Jay

[maxgro]

maybe with replace, ( '<= x <'  is the default)

=replace(class(ID, 10), '<= x <', '-')

[its_anandrjs · Accepted solution]

Hi,

You have to replace the values of the '<= x <' because it is generated by Class function.

=Replace(Class(ID,10),'<= x <', '-')

Regards

Anand

[MarcoWedel]

Hi,

one suggestion. To avoid sorting issues generate a dual value after replacing '<= x <' with '-':

=Dual(Replace(Class(ID,10),'<= x <', '-'),Class(ID,10))

hope this helps

regards

Marco

[#7]

Thanks i manage this and thanks all for good suggestions.

Jay