Hi guys,
If I calculate orders per capita for the following table, Tableau divides the sum of orders by the average of inhabitants. This is the correct outcome, tough, howcome doesn't Tableau take the sum for both columns?
Thanks ^^
| City | Orders | Inhabitants |
|---|
| Amsterdam | 500 | 600000 |
| Amsterdam | 600 | 600000 |
| Amsterdam | 800 | 600000 |
| Rotterdam | 400 | 450000 |
| Rotterdam | 300 | 450000 |
| Rotterdam | 200 | 450000 |
Koen
