Thank you for your reply. I am not quite sure I follow you completely. In Excel I have around 50 tables that are used for the assessment analysis but there is quite a lot of duplication in the tables eg age, gender etc.
I am not sure how to construct one long table? Or quite sure what a star scheme is but the example above by Brian I can do and am working on that now.
I can create the dimension tables for example - age, gender, disability, living alone - these would be in (a) the respondent’s profile table, I could also create (b) location table with location, type of displacement eg refugee, IDP, Host, returnee etc and © assistive aid (product) table.
We also check for access to services eg health, water, shelter, food etc - would this be another lookup table?
We also ask older people about their priorities for assistance. We have 11 things eg water, shelter, food, health, cash, safety etc. For each they are asked to rank on a scale of 0 to 5 then we can calculate the priority ranking for older men, older women, older men with disability, older women with disability, older men living alone and older women living alone. So I can see how age, gender, disability and “alone” would be “slicers” and this latter info would be in the “respondents table” but can or how do I put “priorities” into a lookup table?
I have a sample EXCEL table that I can post (just got to figure out how to post a file - there is help so I will read it then post a sample table
Thanks for all the help