5 Replies Latest reply: Jun 12, 2012 11:37 AM by Andrea Stecca RSS

    selecting which dimensions will affect a chart

      i created a chart thatcalculates EoY forcast for my budget.

      the forcast is calculated as actuall expenses YTD, not including current month and to that i add total expenses of last month multiplied by number of month to EoY.

       

      now, i would like that calculation to be effected by all dimension selections available in that page excludind date based dimensions.

       

      i know it has somthing to do with 'sum({<dimension_name>}expression) where i will detail all dimensions that should effect the calculation,

      but i cant seem to get it work.

       

      any ideas?