Measure in Rows

[razieh12]

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)