Help with pivot table - excluding some data?

[eduller]

Hi - I'm by no means super great at excel or pivot tables. I know enough to create a basic table and that's pretty much it.

I'm trying to figure out how/if I can do this.

I have a spreadsheet with 5 tabs: raw data, Company A monthly summary, Company A yearly summary, Company B monthly summary, Company B yearly summary.

-The data for both companies is combined on the raw data tab.
-For the "Company A monthly summary" tab, I have a normal table (non-pivot) and have used slicers to exclude the Company B data. I have done the same for the "Company B monthly summary" tab.
-For both companies' "yearly summary "
--Is there a way to use the raw data tab to create a pivot table on each company's yearly tab that separates out just that company's specific data? I cannot just hide the data because I need to have counts and totals for each company separately.

I can just create completely separate spreadsheets, but I'm trying to find a way to have them on the same one to reduce the number of files I have to send out.

Thanks!

 

[Anthony47]

I use Office 365, but I'm sure that in Office 2010 you can link the slicer also to a pivot table; so you should be able to create a single pivot from the full table, then have separated view for company A and company B.
Bye

 

[eduller]

Holy moly, that never occurred to me. Perfect, thanks!

 

[Anthony47]