Hi everyone,
I want my worksheet show college average and department average when I switch btw "college" and "department", but it seems tableau just add all the numbers that I have to the "average salary", which is obviously incorrect.
Can anybody help me? Thanks~~
updated!!!
the worksheet is "salary"
I can't open your worksheet, for some reason. How is "average salary" being populated? Is that a calculation on salary field, or has it but entered beforehand on the Source?
Yes this workbook does not match your screen shots. There is not even a department dimension in the data source. But you might want to check what your aggregation is set to on the text marks card. I suspect it is defaulted to sum rather than average. These salaries even at department level seems too high, even for New York or California
Hi.
Your workbook don't have these dimensions and measures. I built using College, Title and White Only.
Apparently worked.
