Discussion Board for collaboration related to Creating Analytics for QlikView.
I have hopefully simplified my problem with calculating commission per period, but just showing a Total
I can show the commissions on a sale, per salesperson, per period.
I would like a separate table that simply sales and Commission
Whilst i can simply do Sum(Gross Sales) for Gross Sales.
Because the Commission is say 5% on the first £1000 per month, then 10%. I need to out commission per period, then Sum the totals
What function should I do to get the Commission to work it out per period, then total?
Thanking you in advance.
Is Sum(Commission) didn't work for you?
Thanks for the quick reply.
in my data I only have the Gross Sales, and the commission is worked out in a Table, so I don't have a lists of Commission Date to Sum.
Thus I can work out the commission per given period,
But I can not have a "summary table"
may be this
May be just this
Sum(GrossSales) as AggrGrossSales,
Sum(Commission) as AggrCommission
Group By SalesPerson;
If i understood correctly, I believe you have Commission Percent for each period and you want to calculate the commission amount. If that is the case may be this
I have in my data, a list of sales, and the day they occurred, and the salesperson.
So I can use basic functions, to total sales per month per sales person.
The commission calculations is on a sliding scale.
So if I break sales down into per month and apply the sales, then I get the commission per month, which the table can total.
I would like a separate table for the total year.
Easy to work out sales for the year, by just
Salesperson SUM(GROSS SALES)
But if I apply the commission formula it will work it out on the Totaled Gross sales, whereas I would like it to work out Commision per month, then totaled
if that makes sense.