3 Replies Latest reply: Feb 13, 2012 7:41 AM by Rahul Rao

# Using group dimension in expression.

hi

i m using this expression in a chart

(Sum(s_revenue)+sum(mrevenue))/(Sum(total <year> srevenue)+sum(total <year> mrevenue))

Its working fine. But actually i want , this expression work for drildown according timegroup dimension  also.

timegroup is group of dimension:

Year

Quarter

Month

Week

Day

So now my expresion should be like.

(Sum(s_revenue)+sum(mrevenue))/(Sum(total <timegroup > srevenue)+sum(total <timegroup > mrevenue)) .

But its  expression showing error and its not working at all. Can we use dimension group in chart expression?

Thanks

• ###### Re: Using group dimension in expression.

Hi,

Use the Expression Like this

(Sum(s_revenue)+sum(mrevenue))/(Sum(total <Year,Quarter,Month,Week,Day> srevenue)+

sum(total <Year,Quarter,Month,Week,Day>mrevenue))

Regards,

Iyyappan

• ###### Using group dimension in expression.

Thanks alot, its working fine.

• ###### Using group dimension in expression.

Hi,

You can use the below expression

= (Sum(s_revenue) + Sum(mrevenue))/

(Sum(TOTAL <Year,Quarter,Month,Week,Day> s_revenue) + Sum(TOTAL <Year,Quarter,Month,Week,Day> mrevenue))

Based on the field in the Drilldown group the dimension in the TOTAL <> is considered and ignores the remaining fields.

Regards,

Jagan.