1 Reply Latest reply on Apr 16, 2018 1:53 AM by Tushar More

    Aggregating a column and assigning a new category

    Ben Gerrish

      Hi Guys,


      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.


      16-04-2018 6-02-58 PM.png


      Kind Regards,