Total number of C is 400 in Dec 17 (200 is from Australia ABC and another 200 is China SION), Australia ABC company grade was A in Sep 17 and China SION company grade was E in Sep 17), hence it is 200 showing in highlighted.
Thanks a lot.
Thanks for your explain, really helpful. Please find my solution attached as well as steps below
1st, left join your data to itself by date and a calculation field as shown below
2nd, create a calculation field and build view like below
Hope this helps
Thanks Zhouyi for your help