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.
+ Add a Comment