Pivot Table Filter on Only Some Columns?

CaptainAly

New Member
Joined
Jul 7, 2017
Messages
1
Hello,
I am attempting to create a pivot table to view how sales trends have changed over time. My data appears as below.

[TABLE="width: 366"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Description[/TD]
[TD]Period[/TD]
[TD]Units Sold[/TD]
[TD]$ Sold[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Week 3[/TD]
[TD]15[/TD]
[TD]$55.20[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Week 3[/TD]
[TD]12[/TD]
[TD]$48.19[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Week 3[/TD]
[TD]9[/TD]
[TD]$62.00[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]Week 3[/TD]
[TD]5[/TD]
[TD]$33.58[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Week 2[/TD]
[TD]1[/TD]
[TD]$17.60[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Week 2[/TD]
[TD]7[/TD]
[TD]$12.97[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Week 2[/TD]
[TD]3[/TD]
[TD]$52.36[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]Week 2[/TD]
[TD]2[/TD]
[TD]$9.78[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Week 1[/TD]
[TD]20[/TD]
[TD]$65.30[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Week 1[/TD]
[TD]13[/TD]
[TD]$11.28[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Week 1[/TD]
[TD]11[/TD]
[TD]$42.67[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]Week 1[/TD]
[TD]2[/TD]
[TD]$39.22[/TD]
[/TR]
</tbody>[/TABLE]

I would like to have one Pivot Table that has all of the Item Descriptions down one side (column A) then in subsequent columns have totals for different dates. Is there a way to filter only certain columns in a Pivot Table?

For example: Columns B&C would be Total Units and Total Sales for all data, then Columns D&E I would only want the Units and Sales for Weeks 2&3, then Columns F&G I would want only the Units and Sales for Week 3.

For now I have solved my issue temporarily by creating three separate pivot tables and inserting a Time Period Slicer on the other two. This is not a permanent solution for me because I have hundreds of Items in multiple categories and I would need the ability to expand and collapse categories and have them expand and collapse across all tables.

I am sorry if this is very primitive, I am completely self-Excel-taught and learning lots every day.

I am using Office 365 on a Mac.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,223,710
Messages
6,174,019
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top