Log In
Register
Home
New Member
October 23, 2020
Offline
Hi
I wanted to know if you help to help make a pivot table. I have this pivot table but I also want to be able to filter the 1,2,3,4,5 as they are the weeks. I have also attached the layout of the table I am currently using. I would like to filter on the blue(different categories) and purple (weeks) squares
Thank you so much
July 16, 2010
Offline
Hi Sha-abaan,
Welcome to our forum!
You need to fix the layout of your source data so that the column labels, 1,2,3... are in their own column and the values are all in another i.e. it's in the correct tabular layout for a PivotTable. Then you can use the PivotTable tools the way they were designed and your filtering will be possible. This PivotTable video illustrates the problem you're having and why.
You can use Power Query to unpivot your source data and then rebuild your PivotTable from the correct tabular layout.
I hope that points you in the right direction.
Mynda
