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.
<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.
I am attempting to create a pivot table to view how sales trends have changed over time. My data appears as below.
Description | Period | Units Sold | $ Sold |
Blue | Week 3 | 15 | $55.20 |
Red | Week 3 | 12 | $48.19 |
Yellow | Week 3 | 9 | $62.00 |
Orange | Week 3 | 5 | $33.58 |
Blue | Week 2 | 1 | $17.60 |
Red | Week 2 | 7 | $12.97 |
Yellow | Week 2 | 3 | $52.36 |
Orange | Week 2 | 2 | $9.78 |
Blue | Week 1 | 20 | $65.30 |
Red | Week 1 | 13 | $11.28 |
Yellow | Week 1 | 11 | $42.67 |
Orange | Week 1 | 2 | $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.