Sum ranks in a pivot table

[JoeMerchant02]

I am displaying three metrics in a pivot table for multiple employees. I have pulled each metric into the pivot table and displayed the second instance as a rank - largest to smallest. I want to rank each employee by the sum of their ranks, i.e.

[TABLE="width: 500"]
<tbody>[TR]
[TD]employee[/TD]
[TD]metric 1[/TD]
[TD]m1 rank[/TD]
[TD]metric 2[/TD]
[TD]m2 rank[/TD]
[TD]metric 3[/TD]
[TD]m3 rank[/TD]
[TD]sum of ranks[/TD]
[TD]overall rank[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]100[/TD]
[TD]1[/TD]
[TD]50[/TD]
[TD]3[/TD]
[TD]75[/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]75[/TD]
[TD]2[/TD]
[TD]75[/TD]
[TD]2[/TD]
[TD]25[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]50[/TD]
[TD]3[/TD]
[TD]100[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Is there any way to sum m1 rank, m2 rank, and m3 rank in the pivot table?

Thanks!

 

[SpillerBD]

You either have to make a value available in the source data to create a Calculated Field or go to a DAX solution with Power Pivot.