Case When would be slightly better option since when you use the IIF statements it creates a new column for each fruit, whereas Case when would give you just one column called calculatedcolumn or you can name it anyway you want. You should put that in the SQL view