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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,224,747
Messages
6,180,719
Members
452,995
Latest member
isldboy

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