I'll have to do so later but to clarify...
There are two axis in the sample chart above of very different data neither of which are aggregated. I want to replicate something like it where the secondary axis is just the value at the date of. So if it is annual, I want the secondary axis to give the value on 31-Dec-2015 - not a sum, max, count etc.
Most likely that can be handled in Tableau's function.
Anyways want to see the data for confirmation.