How to build a Pivot Table with 3 Row Totals

The Table is Below:

Country Project Num Developer Dc13 Ja14 Fb14 Mr14
India IND 10 John Doe 240 240 240 240
India IND 1 John Doe 120 120 120 120
India IND 11 John Doe 1200 1200 1200 1200
India IND 30 John Doe        
India IND 29 John Doe        
Tanzania TAN 1 John Doe       240

Desired Result:

Totals Jan-14 Feb-14 Mar-14
Unique Countries 1 1 2
Total Projects 4 4 4
Total 1560 1560 1800

May 29th, 2015 5:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics