Hi everyone,
Hope you can help out with this.
I want to mark data in a color, based on the data in another pivot field.
In my example I would love Pivot Field (COLOR) to be highlighted when Pivot Field (TYPE) has the value "SPECIAL". So basically any data with the (TYPE) as "SPECIAL" needs to be highlighted.
- Can we do this in a way, that still allows me to use filters and change the pivot table. So (TYPE) does not have to be a specific column. Prefer to keep it in the pivot field list.
- Can we do this without access to the source data? Can't edit as on secure server.
Thank you!
Bookmarks