1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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 !
con risposta 2 anni fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
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.