Hi Randolph, can you re-attach your workbook, I cannot find any attachment.
Sorry about that. Not sure what happened, but have attached the file.
you can use the following calculation
if first() != last()
if ATTR( [Category] ) = 'Other' then 0 else [2016 Revenue]/[2016 Sales] end
[2016 Revenue (woOther)] / [2016 Sales (woOther)]
this calculation must be computing using Pane Down. This way first() and last() will both equals 0 for the Totals, and have a different value for each other cell. This way you can have a different calculation applied on the Total than the one applied on the cells.
Your attempt returns null, because for the Total Tableau don't take the level of detail into account. So for the Total ATTR( [Category] ) was returning null, because there is not a single unique Category in the view. With my solution, I get rid of the ATTR() function for the Total by computing the Revenue and Sales without the Category 'Other'.
Sales (mc).twbx 23.4 KB
Thank you that worked perfectly. I am hanging on to that solution.