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.
Oct 10, 2017 - 4:02am
noph.noph
+ Add a Comment