I need an object where a year and month are selected and a variable for the CustomerPct. So (use data above) if a user selects Feb and 2012 and a CustomerPct of 65%, then the object returns all data from February that has a % of 65% or less. This expression works fine:
This formula doesn't work because if I select February it gives me ONLY February commission. I need February plus all previous months (ie YTD). So choosing Feb 2012 and the variable percent establishes what customer/dept combinations you want but then I need it to be all YTD commissions of that combination...essentially all the lines in blue in my data set and the object shows the result (above).