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!
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!