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
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
That is so much easier than what I was trying to do, and it works perfectly. Have never created a table with that funciton before. Thank you Herbert - you saved me from updating another File every month. Very much appreciated!