when i use SUM function in custom SQL, I am getting error : column reference "sum" is ambiguous. Please help.
ex: select name,company,sum(salary) from employees
Thanks in advance
The sum is an aggregate function so you have to use it with a group by statement. That's why its giving error, so group it by a column such as department and then use sum(salary).
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...