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 ?
