I don't know how you want to simulate max min, and median, bit anyways, I replicated your data by parameters and formula.
if index()<=11 then
Thank you both for reply.
Wasn't quite what I was looking for so I have created a tableau extract and hopefully you would be able to advise
Accountable Profit / (Loss) and Total Net Sales & Transfers are both of my axis'
My Version would be plan, but I would like to plot an actual number as a point, which would indicate if it is above or below the curve.
Chart Test Extract.tde.zip 372.5 KB