Dynamic text that will show different cases depends on values

[Anonymous]

Hello. I have a percentage that I divided into 2 genders, male and female. It looks like this:

So, my problem is kinda complicated. I need to put dynamic text on my dashboard, that will show either all females scored higher that males, or opposite. Ideally, I would like to have the third case, if for example females scored higher in all bars, except something, then the text will be like: 

"The female group scored higher in all attributes except for “smth” ".
Does anyone has an idea? I will be very gratefull.

[tamerj1]

Hi @Anonymous 
Yes that can be done. Would you please provide more details about your source data?

[Anonymous]

As I can't share real names and values, I'm trying to make similar:
a table like:

person_id	_question	_answer	_gender
1  .	some_quest?  .	1st_type   .	male
2  .	some_quest?  .	1st_type  .	male
3  .	some_quest?  .	2st_type  .	female
4  .	some_quest?  .	3st_type  .	male
5  .	some_quest?  .	3st_type  .	female
6  .	some_quest?  .	1st_type  .	female
7  .	some_quest?	1st_type  .	female
8  .	some_quest?  .	2st_type  .	female
9  .	some_quest?  .	2st_type  .	female

Then I calculate simple percentage for each answer, when I divede number of people who answered each type of answer and devide by all people who answered this question by any answer, for example in this table the calculation for 1st_type of answer will be 4/9. 
This percentage I report as bar chart where x-axis is calculated value, y-axis is type of answer and divide it by gender legend.

[tamerj1 · Accepted solution]

@Anonymous 
Apologies for the late reply, I got distracted with some other business.  Here is the sample file with he solution https://www.dropbox.com/t/x57u2iHQmfZyrYPv

Actually this need some improvement. It need to be more dynamic by interchanging between male and female (whoever scores more) and perhaps concatenate the lower scored answered and/or providing counts of higher and lower answers in order to have accurate presentation of the results.