Forum Discussion
Solved
Sum Unique Rows after Unpivot
I have a table with unique rows. I had to unpivot the table based on a column to get a value I was looking for. The problem is, after I unpivot the table, all of the other measures I would try to mak...
I’m not sure the visual/table you want now. If you just want to count the # Seats column for each unique row based on the ID column. Just create a new table with following formula.
Best Regards,
Herbert
Did you end up finding a solution?
You can always randomize some data and send us a dummy file, stripping out any confidential names or values. We just need the table(s) in the same structure.