Hi Mark, like this ?
This is quick and dirty, but as Shin advised its a bit hard to understand what you need without a .twbx showing where you have gotten up to.
The key to this is the calculated field on the dual axis - there are probably more elegant methods of calculating this, but as I noted above, quick and dirty.
HTH 18.2 attached
278437.twbx 2.4 MB