So I'm building a new QVW and this requirement has given me some trouble.
We have order numbers that are assigned to countries, but some are NULL. So we want to assign the NULLs to a country based on the percentage of the country over all the tickets.
For example...
USA - 50 tickets
UK - 25 Tickets
INDIA - 15 Tickets
JPN - 10 Tickets
If there are 20 NULL tickets 50% should be assigned to US, 25% to UK, etc...
