Discussion Board for collaboration related to QlikView App Development.
I have a problem with this formula:
The dimension in the tabel is Salesperson and the problem is that we have two the same Quata's
SalesP1 650SalesP2 650
If you take the formula sum(Distinct Quata) for this example you get 650 as total...
How can i solve this?
Go to Solution.
SUM(TOTAL AGGR(SUM(DISTINCT Quata), Salesperson))
That's right, because of DISTINCT. It group the data first and does the SUM() after that. Use sum(Quata) to get 1300.
This is the correct formula but thanks for the help!
SUM(AGGR(SUM(DISTINCT Quata), [SalesPerson],Quarter))