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,

      Ben