Hello Ross - is it possible to share a workbook with enough data for us to reproduce the issue? Even a crosstab view might tell us what is going on - right click on the Viz Tab at the bottom of the screen in Tableau and "Duplicate as a Crosstab". The percent numbers are coming up too high so this is issue is going to relate to something about how Sum(Net $) being greater than Sum(Total Revenue) when this [Tech Split] is used per Quarter . The crosstab view is a great way to see what the numbers show and to dig into what's going on .
Thanks for your reply - sadly the data in question is company-sensitive and cannot be shared in the public domain. I can however show the same data on a crosstab, as you can see in the image below.
The only field that this occurs in, is when Tech Split is brought into the calculation. Any other dimension called in the "Total Revenue" figure enables the area graphs to perfectly align to 100% of the total. The field is no different to any others, which is why I'm quite confused about why this is happening.
Hopefully this crosstab can help you out, as you can see the Total is still at 100%, yet the figures that contribute towards the total are in and around 140/150%?