Reports with Viewers
I would like to know if there is a way that viewers of the main sheet are able to work with the Reports. I know I can share the report but it seems they are not able to change the "What" choices.
If this is not an option, would it work if I lock the columns and share the worksheet? Then would a collaborator be able to run different options of the report?