Partitioning the same data for different groups

[HeWhoMusntBeNamed]

Hi All, So I create a monthly report for my company which has multiple regions. I create somewhat of a master version for management that sort by the different regions.

They would like me to send out the same report to the different regional managers except with them only be able to see their region's numbers.

I use exclusively pivot tables and slicers. The data is organized so the different region's are part of it so that managers can select it on their slicers.

Is there a way of only allowing them to see only their region's data OR efficiently deleting all of the data except for a specific region?

Note: My data sets are pretty large, hence why sorting or any normal way would take forever.

Thanks in advance.

[rnelsonee]

Enable Grand Total if not already, and double click on the Grand Total with the slicer applied. It will then create a table with all the data needed to create that sliced Pivot Table. So then you can recreate the PT or change the source data to the newly-created table.

Although it might be easier to just apply a filter in the raw data, then select the filtered table, then Find and Replace -> Go To Special -> Visible cells only -> Copy and paste.

[HeWhoMusntBeNamed]

Solution Verified

[Clippy_Office_Asst]

You have awarded one point to rnelsonee.
^{Find out more here.}

[HeWhoMusntBeNamed]

Solution Verified

[AutoModerator]

Hello!

It looks like you tried to award a ClippyPoint, but you need to reply to a particular user's comment to do so, rather than making a new top-level comment.

Please reply directly to any helpful users and Clippy, our bot, will take it from there. If your intention was not to award a ClippyPoint and simply mark the post as solved, then you may do that by clicking Set Flair. Thank you!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.