New to Tableau, and to me it appears that my Calculated Field is producing wrong calculations when also using filtering. Here I've provided a view of my tables and calculation, I am unsure how the values in the table are being reached. For instance with the Arizona Diamondbacks, they produce a salary of 91,482,000 and 1404 hits, giving a salary/hit of 65,158. But the calculation done with the filtered table produces 8,997,524. Any idea where my error is here? I've attached the data, which I also filtered to only include 2013 to produce this result.
1 answer
Just a guess ... try:
SUM([Salary)]/SUM([H])
if that doesn't work, we need screenshots that actually include Rows, Columns and Marks card to see what you're doing with the data.
