how to calculate the total of survey record to match two fields????

%3CLINGO-SUB%20id%3D%22lingo-sub-2386003%22%20slang%3D%22en-US%22%3Ehow%20to%20calculate%20the%20total%20of%20survey%20record%20to%20match%20two%20fields%3F%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2386003%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eanyone%20can%20help%2C%20I%20have%20a%20huge%20list%26nbsp%3B%20I%20need%20to%20find%20the%20total%20of%20feedback%20provide%206-%20Strongly%20Agree%20to%201%20Disagree%20to%20match%20the%20Topic%20to%20the%20Q1%20or%20Q2..%20etc..%20how%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bbsin_0-1622003722563.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283782i61A84993E5BB7A09%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22bbsin_0-1622003722563.png%22%20alt%3D%22bbsin_0-1622003722563.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2386003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2386115%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20calculate%20the%20total%20of%20survey%20record%20to%20match%20two%20fields%3F%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2386115%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612792%22%20target%3D%22_blank%22%3E%40bbsin%3C%2FA%3E%26nbsp%3Bsince%20you%20mention%20%22a%20huge%20list%22%2C%20I%20would%20consider%20using%20Power%20Query%20(PQ)%20and%20a%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20unpivot%20the%20survey%20results%20in%20PQ%20and%20load%20the%20data%20to%20the%20data%20model%20and%20then%20re-pivot%20all%2C%20counting%20the%20number%20of%20occurrences%20by%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20a%20mock-up%20based%20on%20what%20you%20showed%20in%20your%20picture.%20Is%20that%20something%20you%20could%20work%20with%3F%20See%20attached%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2389687%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20calculate%20the%20total%20of%20survey%20record%20to%20match%20two%20fields%3F%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2389687%22%20slang%3D%22en-US%22%3E%40Riny-van-Eekelen%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20will%20try%20out.%3C%2FLINGO-BODY%3E
Contributor

hi 

 

anyone can help, I have a huge list  I need to find the total of feedback provide 6- Strongly Agree to 1 Disagree to match the Topic to the Q1 or Q2.. etc.. how to?

 

bbsin_0-1622003722563.png

 

Thank you

 

2 Replies

@bbsin since you mention "a huge list", I would consider using Power Query (PQ) and a pivot table.

 

First unpivot the survey results in PQ and load the data to the data model and then re-pivot all, counting the number of occurrences by answer.

 

I've created a mock-up based on what you showed in your picture. Is that something you could work with? See attached workbook.

@Riny-van-Eekelen

Thank you will try out.