Pivote table total problem

[#1]

I need first dimension to show in the place of total . output  with red circle is showing in screen shot. and source file also attach. please help me . How should i do that.

[#2]

the closest I can geit is this

or

if either of these are acceptable, I can send you the inforamtion you need