Just a thought.
In cases list this, I have moved away from providing users with reports that they ned up wanting to manipulate.
Consider just creating a .csv file.
Users can pull that into Excel and play until long after you have gone home for the day
The can SUM, AVG, Filter, Hide, etc.
I have found the this substantaily cut down requests for “a report exactly like the other one, just a little different”