Slicer

[therichterscale]

Good morning,
I'm having a hard time adding a second slicer that lists each month. I have one for years, however I would like to add one for the months. What is the easiest method to add one more slicer that has just months. Thank you in advance

 

[therichterscale]

Any ideas?

 

[Joe4]

Please do not mark a post as the solution if there is no solution posted here.
I have unchecked that for you.

 

[therichterscale]

Please do not mark a post as the solution if there is no solution posted here.
I have unchecked that for you.

My apologies, I figured it out. Figured I would close it.

 

[Joe4]

My apologies, I figured it out. Figured I would close it.

You can do that if you post your solution.
But only actual solutions should be marked as such.

 

[therichterscale]

Here is my solution...

With headers (Year, Month, Total) list and repeat the year with each month and the total. In the field list of the pivot table, Year is placed in the columns area, month in rows and values is the sum. From there, I am able to select year and month on two separate slicers. Now I can compare any year and the corresponding month or a group of any combination. See below:

Data

Pivot table field

Slicers