Forum Discussion
Comparing values of the same column
Hi everybody, my english is so bad, but I need your help to create a matrix visual like the photo attached.
1)I want to compare the prices from a list that I have. (point 1) Dividing the price of each product row for a column transposed of the same list of products (point 2), as result a matrix with values in percent (point 3) for the purpose of concluding if products A,B,C are more expensive or cheaper than the rest of products. (point 4).
I hope you can understand me <3
P.S: I think that it's a linear algebra problem because de column is (n rows x 1 column) multiplying the column transposed ( 1 row x n columns) as result a matrix (n rows x n columns). Example: 4 products generate 16 possible results.
4 Replies
- Ashish_MathurSuper User
- joshuacisnerosRegular Visitor
OMG!!!!, Thanks a lot, your solution it's perfect! That was exactly what I was looking for.
- Ashish_MathurSuper User
You are welcome.