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:

Stock #	Item Code	QTY/Current Month	Min of Current Month	Max of Current Month	QTY/Month Ahead	Min of Month Ahead	Max of Month Ahead	QTY/2 Months Ahead	Min of 2 Months Ahead	Max of 2 Months Ahead
16392	CNMG 432 PM4325	141	212	282	125	188	251	110	165	220
16399	CNMG 432 PF 4315	9	14	18	8	12	16	7	11	14

<tbody>
</tbody>

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.