Discussion Board for collaboration related to Creating Analytics for QlikView.
Trying to get this calculation in a table.
So the ETE% is a division of Count of product a by total count of All products for the Salesrep + added
common products for other salesreps.
So for example, the first line would be:
10 / (10 + 10 + 10 + 20 + 20) = 14%.
How do I count all the products for a Salesrep + add sales of common products to Salesrep James.