Dynamic table based on slicer

[AGaribay7]

So, I have a table like this:

Player Number	Shots	Shots on target	Pressures	Recoveries	Key Passes	Assists
Player 1	0	0	1	0	1	1
Player 2	2	1	2	1	0	0
Player 3	1	1	1	0	1	0

I want to create groups:

Group 1 = Shots and Shots on target
Group 2 = Pressures and Recoveries
Group 3 = Key Passes and Assists

Use groups in slicer, and based on the slicer change table data.

When selected Group 1 in slicer:

Player Number	Shots	Shots on target
Player 1	0	0
Player 2	2	1
Player 3	1	1

When selected Group 2 in slicer:

Player Number	Pressures	Recoveries
Player 1	1	0
Player 2	2	1
Player 3	1	0

When selected Group 3 in slicer:

Player Number	Key Passes	Assists
Player 1	1	1
Player 2	0	0
Player 3	1	0

Can anyone help me ?

[lbendlin]

You cannot create a calculated column or calculated table from a measure/slicer/filter.