Filtering Columns in Reports
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data.
1) How do I restrict the datas in the columns that have to be shown
2) If out of 4 child rows, 3 pertain to one department and 1 pertains to another, how do i only show them the relevant information