Dimension

[NavinReddy]

Hi All,

Could some one help me this Query

Is it possible to use Expression in Dimension (one interviewer asked this Question)

Thanks in Advance

Niranjan

[Sokkorn]

Hi Miranjan,

Yes it possible. Example

=If(Field=value,'A','B')

=Aggr(Only( {$<Product = {'AB*','BB*'}>} Seller ),Product)

Regards,

Sokkorn

[Anonymous]

Yes,

you can use aggr function to expression and it can be used as dimension.

suppose you want to use sum(sales) as  dimension and have country as dimension previously.

then new calculated dimension will be,

aggr(sum(sales),country) .

Regards

Nitin

[NavinReddy]

Thank you to all