1 Answer
- Newest
- Most votes
- Most comments
0
Hello,
Thank you for reaching out to us.
In order to replicate the use-case, I created a dataset(in excel) as below :- values colour 75 GREEN 67 GREEN -79 GREEN -107 RED 53 RED -79 GREEN
Then i created an analysis (type : pivot table) from the above dataset. Go to Conditional formatting ->
- Column -> values
- Format field based on -> colours
- Aggregation -> No Aggregation
- Condition#1 -> Equals
Value - > GREEN (in the right check box 'color', I choose green colour)
- Add Condition Condition#2 -> Equals Value - > RED (in the right check box 'color', I choose red colour)
Attaching screenshots for your reference.
Thank you !
answered 2 years ago
Relevant content
- Accepted Answerasked 4 years ago
- asked 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
Hi, thanks for your response, but it didn't answer my question.
How do I get the "No Aggregation" option to appear? This is the question I'm asking.
You say to select "No Aggregation." This is what I want to do. The problem I'm running into is that it doesn't give me the option to select "No Aggregation." It only allows me to select "COUNT" or "COUNT DISTINCT" as I've shown in the image in the original post.
How do I get the "No Aggregation" option to appear?
Thank you for your help.