SkiliedSin
Board Regular
- Joined
- May 7, 2018
- Messages
- 51
- Office Version
- 365
Hello,
My current raw data table reads:
Monday Tuesday
Black Red Black Red
Car 10 15 6 7
Horse 4 2 2 6
Bike 7 3 4 5
Wagon 8 1 5 3
Is there any way to pivot this and have the filter as the colors? (Black & Red)
I can currently pivot it by vehicle (Car, Horse, Bike, Wagon) with the days of the week at the top (Monday & Tuesday) but I am trying to have a filter for the color as well.
My current raw data table reads:
Monday Tuesday
Black Red Black Red
Car 10 15 6 7
Horse 4 2 2 6
Bike 7 3 4 5
Wagon 8 1 5 3
Is there any way to pivot this and have the filter as the colors? (Black & Red)
I can currently pivot it by vehicle (Car, Horse, Bike, Wagon) with the days of the week at the top (Monday & Tuesday) but I am trying to have a filter for the color as well.
Last edited:
