I have some data with various dimensions - one of which includes 'Colours'. I've also got a matrix between Colours and Cities separately (e.g. in the attached) which allocates Colours to Cities on a percentage basis.
What I need to do is convert my data using the mapping to go from Colours to Cities. I'd normally be able to do this just by adding Cities as a dimension, multiplying the data by the matrix and then stripping out Colours. Unfortunately I don't have the space to have both Colours, Cities all the other dimensions.
Is there a way to get this allocation done without having all the dimensions in one line item?
Hope that makes sense.