I have a chart with sales people and number of units moved.
The business is asking that where two sales people collaborated on sales, the chart show the split in the numbers next to their name.
So for example if Bob and Ted sold 100 units, the chart would look like this:
The issue is that when the total units is 101, they would like to see, essentially:
How can I force the format to truncate decimals without changing the actual value behind the scenes?