Hi I have three drop down fields on Opportunities that have Codes in them - Field A , Field B and Field C - each of these field have the same value list in the dropdown. I want to run a report on Opportunities and count the no of times a value appears regardless of which field it is selected in. Eg Opp 1 Field 1 = A Field 2 = B Field 3 = C Opp 2 Field 1 = B Field 2 = D Field 3 = C Opp 3 Field 1 = E Field 2 = A Field 3 =B So My report should show the following count A = 2 B = 3 C = 2 D = 1 E = 1 If possible it would be great to be able to group by the Values and show the Opps underneath A = 2 Opp 1 Opp 3 B = 3 Opp 1 Opp 2 Opp 3 etc

Summary Report

I have three drop down fields on Opportunities that have Codes in them - Field A , Field B and Field C - each of these field have the same value list in the dropdown.

I want to run a report on Opportunities and count the no of times a value appears regardless of which field it is selected in.

Opp 1

Field 1 = A Field 2 = B Field 3 = C

Opp 2

Field 1 = B Field 2 = D Field 3 = C

Opp 3

Field 1 = E Field 2 = A Field 3 =B

So My report should show the following count

A = 2

B = 3

C = 2

D = 1

E = 1

If possible it would be great to be able to group by the Values and show the Opps underneath

A = 2

Opp 1

Opp 3

B = 3

Opp 1

Opp 2

Opp 3

etc