I have a huge national workbook, which contains US data across all dimensions and measures (population, GDP, etc.). I would like to dynamically split the workbook to individual state workbooks with the same fields. I am currently using Custom SQL to filter it on something like 'where State = New York'. Ideally I don't want to hard code this and change it for all 50 states.
Is there anyway to automate this process? I have explored filtering the data when first connecting to the extract, but again this is a manual process.