Could you post a packaged workbook with some sample data? It's hard to answer your question without knowing what aggregations are being performed, etc.
Sorry but I don't feel comfortable posting any data.
I will try to explain the issue with theoretical data, if this is not clear please have somebody contact me.
Company A sales:
The whole week $27
Company A+B+C+D+E sales:
The whole week $91
When the data is rolled up to the week level I would expect to see that Company A has 29.7% of sales (27/91). However what I actually see is 50%+25%+29.4%+26.7%+25%+33.3%+20%+29.7%=209.4% or a sum of daily percent sales for the week long period.
Can you provide a spreadsheet with the mocked up data? I'm still not clear on whether Company A, B, C, D, etc. sales each get one row per company/date, or whether the total sales are an additional column, etc. Even better would be a Tableau workbook using that mocked up data and your calculations so far, then we'd be able to help point to exactly where the calcs are returning incorrect results.
If someone could contact me directly it would be greatly appreciated.
You haven't made your email address available to other forum users, so we can't contact you directly. If you'd prefer to work with Tableau tech support, their email is firstname.lastname@example.org, otherwise you can reach me at jonathan (dot) drummey (at) gmail.