I think those ATTR functions may not be working for you.  I'm not used to seeing those around measures, and if there is more than one value in the data set within the dimension you're in, ATTR returns an asterisk.

If you could add a few more columns to that spreadsheet you could use it as a Tableau data source.  Then you'd be able to post an almost-working packaged workbook to this thread and you'd gets lots of help.

I worked on this a bit, and here's the excel file I was using (with the extra columns).

--Shawn

See what you think of this, no ATTR required!  A few more tweaks to the table format will get it to appear as one.

Allyson, it looks like the TWBX you posted was created in Tableau 6.0 or earlier.  My revision uses 7.0 but doesn't use any 7.0 features.  I could redo it in 6.1 if that helps but I don't have 6.0 or earlier any more.

6.1 WON'T work if all you have is 6.0.  Please let me know before I redo it.  This is a constant problem because forum responders are typically using the latest version while forum questioners are often stuck with an earlier version because they haven't upgraded their production environment.  We're still using 6.1 in production but I'm practicing with 7.0 whenever possible.

UPDATE: I found a copy of 6.0 and am redoing the changes in that version for maximal compatibility.

Workbook attached.

Message was edited by: Zach Leber