Expression as a dimension

[NareshGuntur]

I have a table

A	Sum(C)
a1	10
a2	15
a3	20
a4	25
a5	30
a6	35

I need a dimension, something similar to class function

if(Sum(Aggr(Sum(C),A))>=10 and Sum(Aggr(Sum(C),A))<20,'Low',

if(Sum(Aggr(Sum(C),A))>=20 and Sum(Aggr(Sum(C),A))<30,'Medium','High'))

So, I want Low, Medium, High as Dimension values and then want some expressions to be aggregated based on the calculated dimension.

Thanks

Naresh

[sunny_talwar · Accepted solution]

Try this

Aggr(

If(Sum(C) >= 10 and Sum(C) < 20, 'Low',

If(Sum(C) >= 20 and Sum(C) < 30, 'Medium', 'High'))

, A)

[Anil_Babu_Samineni]

Will you able to create calc. dim like below?

=if([Sum(C)]>=10 and [Sum(C)]<20,'Low',if([Sum(C)]>=20 and [Sum(C)]<30,'Medium','High'))

Or

=if(Aggr(Sum([Sum(C)]),A)>=10 and Aggr(Sum([Sum(C)]),A)<20,'Low',if(Aggr(Sum([Sum(C)]),A)>=20 and Aggr(Sum([Sum(C)]),A)<30,'Medium','High'))

[NareshGuntur]

Thanks Sunny

[NareshGuntur]

Thanks Anil. I tried this.