Sharing a report
I have an inquiry about sharing a report as I would like to know if we have a way to share the report without sharing the original source sheet.
I create a report "QA report" that getting data from a source sheet named "Quality Checks". The filter of the QA report will be the name has any of "current user" which I will get the users to see their specific rows of data only. However, if I share the source sheet named Quality checks, the data will be shared to everyone which we shouldn't do that because it breached the private and confidential policy.
Please could anyone advise if there is any alternative way to make this happens?