This content has been marked as final. Show 2 replies
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