Hello
I have a question and appreciate if someone provide me with the solution.
My data is 2 tables: Speed Table and Productivity Table.
Speed Table:
City | Column1 | Column2 | Column3 |
A | 1 | 6 | 1 |
B | 4 | 9 | 4 |
C | 0 | 9 | 3 |
D | 1 | 5 | 9 |
A | 8 | 7 | 0 |
B | 9 | 1 | 6 |
C | 0 | 7 | 4 |
D | 1 | 8 | 3 |
Productivity Table:
City | Fac1 | Fac2 |
A | 1 | 6 |
B | 4 | 9 |
C | 0 | 9 |
D | 1 | 5 |
A | 8 | 7 |
B | 9 | 1 |
C | 0 | 7 |
D | 1 | 8 |
And I want to create this matrix from these tables
by grouping by the data of speed table and productivity tables and pivoting them and appending these two table I can create the below matrix:
My main challenge is the Fac1/Fac2. I dont know how to add this measure in the maxtrix. I appreciate it if some one can help me. Fac1/Fac2 means divide( Fac1,Fac2).
the values in matrix is the calculate (sum( column1)), calculate (sum( column2)),calculate (sum( column3)),calculate (sum( fac1)),calculate (sum( fac2)), divide( Fac1,Fac2)
