Display percentage from different row
I wanna show today value and its achievement in KPI Chart as shown below.
This is the sampel of my table :
|12/31/2016||30,000 $||Last Year|
|12/31/9999||100,000 $||Target 2017|
How to display its achievement? or maybe I can't use KPI Chart? Which chart that suitable for my needs? Please help about this.