If you do a table calc filter for "Our Company", it'll display whatever satisfies the filter, but still give the TOTAL for all rows, not just your company.
Table calc filters don't discard rows like a quick filter does. It just governs what will get displayed, but still leaves the underlying table intact.
Consider a table calc like this:
LOOKUP( IF ATTR([Manufacturer]) = "Out Company" then 1 else 0 end)
Put that on your filter shelf and select for value = 1.
Thanks for the response. Unfortunately when I put that on the filter shelf the only value is "Null". The more I read up on it, and the more I try and get something to work, the more I think I should just pull everything into an Access database to create an additional element in the Manufacturer Dimension for "Total Industry" - would be a simple enough create table query, with an append query of all the data grouped together. Hate doing that kind of thing though.
I could take a look at it if I had a packaged workbook.
You could pare it down and address any proprietary concerns if you follow the steps in the video posted here: