Switch between different PivotTable Fields for Values

[EdwardJ02]

Hi,

I have an excel file where employees can submit projects they are working on and amount spent on the project each month. The names of the months are therefore in the columns as headers. When I make a PivotTable out of the table I have the persons in the Row sections and the month I want to see in the Values section of the PivotTable. Looks like this.

I can create a Slicer for the persons if I want to filter between different people. But because each month is it's own PivotTable Field I cannot create a slicer for the months.

Is there I way I can create something that mimics the function of a Slicer so I can easily switch between the months without manually unchecking the month selected and selecting the next month in the PivotTable.

Thank you in advance and let me know if there is more information you need from me!

 

[EdwardJ02]

So I found this video as a solution to my problem.

.

I used the VBA code from the video and adding this string to add the PivotTable Field again, so it works like a loop. So in total I had to create 12 macros, one for each month. And it works in a chronological order, so after January you have to click the macro for February, otherwise the order gets messed up.

ActiveSheet.PivotTables("PivotTable7").AddDataField ActiveSheet.PivotTables( _
        "PivotTable7").PivotFields("November"), "Sum of November", xlSum

Maybe someone got a better solution. But now I can flip through the month and see how much each employee spent on projects that month.