Forum Discussion
Convert three columns with repeating rows into a primary key, field columns, and associated rows?
Pivot the demographic column (demographic values in the Values section) and "Don't aggregate" under Advanced.
I think that's what your after.
Let me know.
Apologies for the late reply. I try not to worry too much about performance until it becomes an issue. If you follow good practice for designing the model (bearing in mind the user requirements) i.e. get the granularity of the fact tables right, create a star schema with dimension tables to slice and dice the data, you can't go far wrong.
I think the main issue you face at this stage is this part "want to keep their options open". The ideal of presenting a dataset which is a utopia for users is a bit of a pipedream. So try to get a few examples of what they want to do (even if they want to replicate existing reports).
Good luck.