I have a number of calculated fields I've created to reassign numbers to different states; the result is I have a column (calculated field) for each state I.e:
NSW / VIC / WA
I'm trying to now group these columns into one dimension such as 'state' that refers to the new calculations. Is it possible?
I have a state dimension, but it is incorrect, as the calculated fields define the correct state value after a percentage change and each state will either gain or lose a portion of it's value.
Have you tried splitting the column?