Thanks for trying to help, Brad. I really appreciate it!
I have tried using CNTD instead of SUM on the shelf but it reports a value of "1" for each one of my performance levels. Any suggestions?
I don't know how your data is set up. However, something like
IF [Test] = "Math" Then [Level] END
IF [Test] = "Math" AND [Level] = "A" THEN [Score] END
If neither of these help you, then could you attach a mock-up or .twbx file?
Thanks so much for looking at this.
I did a mock up to try to illustrate the problem. I attached the Excel sheet with two tables and the packaged workbook. On the Tableau file, you can see how I try to count the number of students scoring at 4 different performance levels on their standardized English test. Although their are only 5 different students, it gives me a sum of 15 scores as it counts each student 3 times. On the joined table, each student is listed three times.
Thanks a ton, Brad!!