Trying to sum up a data. So I have a column named Tickets, the next column is the amount of that ticket in a number format. I have several tickets with the same ticket number. I want to sum up the total amount of the same ticket number. For example. Ticket # 10 = 200, Ticket # 11 = 300, Ticket # 10= 50. I want a script that will look for duplicate ticket numbers and then add up to give the result in this case of 250. I created an additional column for the data I just am lost on creating it.
Why do you need an additional column? just create a measure Sum(Amount) and use dimension as ticket number.
Please explain in more detail. You can add another column /table with this rolled up data using resident load and group by. but share more details please
Why do you need an additional column? just create a measure Sum(Amount) and use dimension as ticket number.
Please explain in more detail. You can add another column /table with this rolled up data using resident load and group by. but share more details please
