2 Replies Latest reply: Jun 14, 2013 4:03 AM by maartenvdb RSS

    Need help with expression, targets made per employee per year

      Hello,

       

       

      I am trying to create a graph that will show the amount of targets made per employee per year.

      I came as far as the expression

      Sum(if(Sum(ORDER_unit_sale_price * ORDER_quantity)>= TARGET_sales_target, 1))

      and I am using the dimensions TARGET_YEAR_nr, SALES_STAFF_code and PRODUCT_number.

       

      Somehow nothing will show up in my object. I think I have to use the aggr function but I don't know very well how it works..

       

       

      I did get the total targets to show stacked with the actual sales by putting two expressions:

      Sum(ORDER_unit_sale_price*ORDER_quantity)

      and

      Sum(TARGET_sales_target)

      with dimensions YEAR_nr and SALES_STAFF_code

       

       

      I attached my qv file.

       

      Thanks in advance for any help