Group by/sum alongside multiple attributes
I'm facing the below problem (probably there is an easy solution, however I'm too much immersed into it that prevents me to find it). 🙂
I have an excel database where I have several attributes and a value in the columns. I created a unique key manually in order to upload it into Anaplan. So now I have in Anaplan exactly what I have in the excel. I made some transformations (i.e.: in the excel I have the lowest cost element level, while in Anaplan I need a few lever higher cost element category), up till now it was an easy task.
Now, I would like to group/sum the values from some of the lines where all the attributes are equal (i.e.: values in column A/B/C/D are the same for each lines) and leave the rest as it is.
I tried to create a unique key by concatenating the different attributes into one field, then putting them into a list in order to make the aggregation possible using the 'sum' function. My issue is that the key created like this is quite long, thus I cannot create a list from this key and I cannot figure out any other solution to do this type of aggregation.
I attached a simplified example, maybe it's more talkative than my explanation above.
Any help would be highly appreciated!