Grouping Columns in Pivot Table and use Timeline/Slicer to select group

[Mechixx]

Hello there everyone!

Im wondering if its possible to do this or not, or maybe some way i can achieve this.
What i want to do is make a few groups of a few columns each in a pivot table, and then be able to use a slicer or timeline to be able to select which of the groups i want to see at any given time.

Here's an example of my pivot table:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Stock #
[/TD]
[TD]Item Code
[/TD]
[TD]QTY/Current Month
[/TD]
[TD]Min of Current Month
[/TD]
[TD]Max of Current Month
[/TD]
[TD]QTY/Month Ahead
[/TD]
[TD]Min of Month Ahead
[/TD]
[TD]Max of Month Ahead
[/TD]
[TD]QTY/2 Months Ahead
[/TD]
[TD]Min of 2 Months Ahead
[/TD]
[TD]Max of 2 Months Ahead
[/TD]
[/TR]
[TR]
[TD]16392
[/TD]
[TD]CNMG 432 PM4325
[/TD]
[TD]141
[/TD]
[TD]212
[/TD]
[TD]282
[/TD]
[TD]125
[/TD]
[TD]188
[/TD]
[TD]251
[/TD]
[TD]110
[/TD]
[TD]165
[/TD]
[TD]220
[/TD]
[/TR]
[TR]
[TD]16399
[/TD]
[TD]CNMG 432 PF 4315
[/TD]
[TD]9
[/TD]
[TD]14
[/TD]
[TD]18
[/TD]
[TD]8
[/TD]
[TD]12
[/TD]
[TD]16
[/TD]
[TD]7
[/TD]
[TD]11
[/TD]
[TD]14
[/TD]
[/TR]
</tbody>[/TABLE]













So what i would like to do is group:

Current Month Group:
QTY/Current Month
Min of Current Month
Max of Current Month

Month Ahead Group:
QTY/Month Ahead
Min of Month Ahead
Max of Month Ahead

2 Months Ahead Group:
QTY/2 Months Ahead
Min of 2 Months Ahead
Max of 2 Months Ahead

And then have a slicer/timeline so i can select which group i want to look at to more cleanly see information instead of all muddled together. Is this even possible? or is there a way i can achieve this?

Any help on this is greatly appreciated. Thank you!

 

[Mechixx]

Another idea i had on this, is i could maybe just have 3 separate pivot tables that have the info.. But i think it would be a lot tidier looking to be able to have a slicer or timeline be able to split the data apart. if i have to add specific months for the timeline to work I'm not opposed to that either.