Zend certified PHP/Magento developer

Display Custom Reports on Magento 2 Sales Orders Page

I’m working on a Magento 2 project where I need to display custom reports under the order grid on the Sales Orders page. Specifically, I want to show the following fields:

  1. Total (totals sum)
  2. Subtotal (subtotals sum)
  3. Shipping (shipping sum)
  4. VAT (VAT sum)
  5. Quantity (quantities sum)
  6. Number of Orders
  7. Number of Canceled Orders

Initially, I attempted to achieve this using an observer, but I faced difficulties in accessing the filtered orders collection or the underlying query.

Now, I’m considering implementing a solution using a plugin. Could experienced Magento developers provide guidance on how to tackle this problem effectively? Any insights or alternative approaches would be greatly appreciated.

Feel free to ask for further clarification if needed. Thank you!