Forum Discussion
How to fix the values in Matric
Hello Every one,
I have a matrix for origin and destination like below.
How can I fix the row and column count from the table? Please help me on urgent bases
I have attached the sample data for reference.
https://drive.google.com/open?id=1HMa3KGx_8sgbepdoU0B9aVhC2WSRHIQz
Ex: For origin 1: Sum is 321 and same origin count is 268, how can I add 321+268
2 Replies
v-piga-msftResident Rockstar
Hi Anonymous ,
I cannot see your sample data with your URL. If it is convenient, could you upload that URL again?
In addition, I have a little confused about your requirement.
How do you show the 321+268? Do you want to show it in Matrix?
Best Regard,
Cherry
Sample Workbook,
https://drive.google.com/open?id=1HMa3KGx_8sgbepdoU0B9aVhC2WSRHIQz
I just want to Add each row sum and column sum and want to represent the total with respect to each code
Something like below.