It drives me bonkers that users who are editors on a report and the source sheet for that report cannot group or filter the report. In my use case, each user has a report that contains data that only applies to them, taken from a master data source sheet. I want each user to be able to filter or group their data as needed. None of that affects the source sheet, so I truly do not understand why it would be an issue for users to have that capability. They can have their report filtered or grouped how they like it, but it doesn't affect the source sheet. It would also be great if they could add or delete rows. Being an editor on a report is nearly meaningless.
