Access to Reports

Hello! I know that in order for someone to see the data in a report, they need access to the source sheet. I have been tasked to make reports for management off our team data - but with only certain columns viewable to them. If I give them access to the source sheet, then I am not really making columns not viewable and my report is not useful. Is there a workaround to this?

Answers