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

    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