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