KongGulerod
New Member
- Joined
- Feb 23, 2017
- Messages
- 17
- Office Version
- 2013
- Platform
- Windows
I have a dataset that I view in a pivot table. To make it easier to view I want to color the table based on the total of the group. If the group total is blank I want it to have a color. But I also want the rest of the fields in the group to be colored. Is it even possible? The data is dynamic and is changed on a weekly basis. The original data is not about what people drink...
Data example:
The Pivot looks like:
My conditional rules looks like:
What I really want my Pivot to look like (colored by hand):
I can not seam to find a solution.
I fear it's not possible.
Data example:
Department | User | Drink |
Dep1 | Usr1 | Beer |
Dep2 | Usr2 | Beer |
Dep3 | Usr3 | Wine |
Dep1 | Usr4 | Water |
Dep2 | Usr5 | Beer |
Dep3 | Usr6 | Beer |
Dep1 | Usr7 | Water |
Dep2 | Usr8 | Water |
Dep3 | Usr9 | Beer |
Dep1 | Usr10 | Beer |
Dep2 | Usr11 | Wine |
Dep3 | Usr12 | Wine |
Dep1 | Usr13 | Beer |
Dep2 | Usr14 | Beer |
Dep3 | Usr15 | Wine |
Dep1 | Usr16 | Water |
Dep2 | Usr17 | Beer |
Dep3 | Usr18 | Beer |
The Pivot looks like:
My conditional rules looks like:
What I really want my Pivot to look like (colored by hand):
I can not seam to find a solution.
I fear it's not possible.