It's hard to say for sure without seeing the workbook, but my guess is that the strings defined in this calculation are not the same as in the Grouping field. Maybe there is an extra space in the Grouping member names? If you can post the workbook (twbx file), I can take a closer look.
Hi Tracy -
Thanks for offering to help. I just started using Tableau last week. It is pretty cool but I'm stuck with this issue.
On the "Dashboard 1" sheet, I want to multiply Stage 0-2 open pipe with corresponding close rate (16.9%) and so on. Then add them all up. I want to keep close rate variable change as per weeks left (from "Prod Yield Rate-All Rep Level.xlsx").
On "Open Pipe Yield", I'm trying different ways of getting it. It works when I hard code the close rate but not as a variable.