Using group dimension in expression.

[#1]

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

[v_iyyappan · Accepted solution]

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

[jagan]

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.

[#4]

Thanks alot, its working fine.