Hi Brainstrust,

I have several (about 10) workspaces that are used for different Regions. Each region has it's own discrete data, although the data tables are the same structure in each of the workspaces. Each region makes bookings, and has costs associated with their bookings.

I want to create a 'national' workspace that will provide totals of all the regions, and the ability to slice and dice using filters, drill-down etc.

I am assuming I am going to have to 'duplicate' the data into the 'National' workspace table. Using a new workspace based upon the other 'region' workspaces, so the filters and views are the same. The National dashboard may have an extra filter that will be able to filter based upon a column value of Region. 

I notice that you can import data from other workspaces. Because I need to import from more than one workspace, is this the way to go, or should I simply import from the same sources as the other workspaces import their data from?

Normally, I use the delete all and add again setting for the data. This would not work for the National database because it will remove all the data that has been imported from the other workspaces.