Sum of 5 columns then take top 3 of these columns?

[Guest]

Hi,
I got stuck - please help.
I have a repport need to pull out sum of 5 columns then take top 3 value 5
of these column, filed is YES/NO, ex:
Col1 Col2 Col3 Col4 Col5
1 0 0 1 1
1 1 1 1 1
Then Sum will be:
Col1 Col2 Col3 Col4 Col5
2 1 1 2 2
How can I pull out to report and name;
Col1: 2
Col4: 2
Col5: 2
Thank you for reading and any suggestion.
NM

 

[Guest]

Hi MN,

I have a suggestion for you, but before I post it, I need to know how you
will handle having 4 columns with equal value, eg:

col1 - 2
col2 - 2
col3 - 2
col4 - 2
col5 - 1

How are you going to pick the top 3 from that?

Damian.

 

[Guest]

Thanks for replied
Yeah, If have 4 cols equal values then I take the col #3. If I have 5 cols
equal value then I will take to col #3.
Regards,
MN