I'm trying to create a table with employee code, name, last name and degree. The problem is that some eployees have more than 1 degree so they appear multiple times.
I only want it to show the unique employee code with their highest degree.
I have tried to use calculated dimensions but so far I only get errors.
If employee code can only have one name & last name you can have degree as a calculated dimension. But this is easier to do by using a single expression in your table to control what values to display and display like a "x". But as a calculated dimension, try making degree as:
