Display percentage from different row

Hi, 

I wanna show today value and its achievement in KPI Chart as shown below.

 

This is the sampel of my table :

Date Amount Remarks
12/31/2016 30,000 $ Last Year
10/11/2017 55,000 $ Yesterday
10/12/2017 58,000 $ Today
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.

Many thanks.

Login