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.

DescriptionPeriodUnits Sold$ Sold
BlueWeek 315$55.20
RedWeek 312$48.19
YellowWeek 39$62.00
OrangeWeek 35$33.58
BlueWeek 21$17.60
RedWeek 27$12.97
YellowWeek 23$52.36
OrangeWeek 22$9.78
BlueWeek 120$65.30
RedWeek 113$11.28
YellowWeek 111$42.67
OrangeWeek 12$39.22

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

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 to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,215,374
Messages
6,124,573
Members
449,173
Latest member
Kon123

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