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

    Need help with expression, targets made per employee per year




      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:




      with dimensions YEAR_nr and SALES_STAFF_code



      I attached my qv file.


      Thanks in advance for any help