Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I get my data at a Division level earliest every quarter, for all income statement accounts.
Year | Quarter | Division | Written Premium | Earned Premium | Losses |
2010 | 1 | North America | 20,000 | 18,000 | 10,800 |
2010 | 1 | Europe | 12,000 | 12,000 | 8,400 |
2010 | 1 | Asia | 15,000 | 10,000 | 6,500 |
Then, a week later I get my data for Written Premium only broken out by country, which I can map to a division.
Year | Quarter | Country | Written Premium |
2010 | 1 | USA | 14,000 |
2010 | 1 | Mexico | 2,000 |
2010 | 1 | Canada | 4,000 |
2010 | 1 | London | 8,000 |
2010 | 1 | Ireland | 4,000 |
2010 | 1 | Singapore | 15,000 |
Country | Division |
USA | North America |
Mexico | North America |
Canada | North America |
London | Europe |
Ireland | Europe |
Germany | Europe |
Japan | Asia |
Egypt | North Africa |
So I'd like to have my one income statement account be able to drill down, or have charts showing it by country.. and every other income statement account shown by division. An added layer is that I have Forecast data by Country and Division.. but that is for another day. How should I set up my tables to not have synthetic keys? I'd like to add that waiting for the by Country data for Written premium isn't an option. Thanks for any help.
Here is a slightly modified version of the solution proposed by Carlos Reyes, giving the correct totals.
Is this what you want?
Here is a slightly modified version of the solution proposed by Carlos Reyes, giving the correct totals.