6 Replies Latest reply: Aug 17, 2015 9:18 AM by Matt N RSS

    Combine Calculated Dimension into Expression.

    Matt N

      Combine Calculated Dimension into Expression.

       

      I have a chart reporting correct data by using the following Calculated Dimension and Expresssion: I need to combine these two parts into a single expression but have run into a road block on how to combine them.

       

      I need to sum the metric in week2 for those who had more in week2 over week1.

       

      Working Chart:

      Calculated Dimension:

       

      =AGGR(

        IF(sum({1<FieldWeekStart = {'$(vWeek2)'},Vendor={'CompanyA'}>} $(vMetric))

        >=sum({1<FieldWeekStart = {'$(vWeek1)'},Vendor={'CompanyA'}>} $(vMetric)),'Growth'

      )

      ,CompanyKey)

       

      Expression:

      sum({1<FieldWeekStart = {'$(vWeek2)'},Vendor={'CompanyA'}>} $(vMetric))

       

      Message was edited by: Matt N I took a work around to get the data in the layout needed (Horizontal accumulation with two dimension.) Rangesum(Before(sum({1<FieldWeekStart = {'$(vWeek2)'},Vendor={CompanyA'}>} $(vMetric)),0,ColumnNo()))