I extracted the data like your suggestion.
So sorry about the first mistake.
Thanks for your workbook wit extract.
Please find my solution attached as well as steps below
Hope this helps
1 of 1 people found this helpful
Zhouyi has solved your problem. But just to show you where you have the issue, there are 22 rows for blank order_id_delivered with a row for different restaurants.
So when you show grand total it calculates the countd(your calc) of all of the data as opposed to sum of the numbers on the chart. You might just want to exclude this order_id
and your grand total will work fine.