There are no out of the box webparts to do this. I would use Power BI abd embed in the page, you can use a SharePoint List as a data source. You will be a Power BI licence if you don't have an E5 and for any other users who want to view the webparts on that page
@prins063 you would need a Power BI Licence as that is not in the Business Essentials.
Having given it some more thought, you could also export to Excel and then add total row to the table. You would need to manually update the Excel file when you view it but can still embed in a page using the embed document webpart
There is no data refresh action for the Flow Excel connector. You could also use a Power App but getting a large list will require the use of a collection and multiple retrievals to get the correct totals