Pivot Table Data Example

Sum - Revenue Company Year Month FirmA FirmB Total Result 2009 777 736 1513 February 69 50 119 March 128 140 268 April 78 126 204 May 67 17 84 June 88 83 171 July 24 14 38 August 65 48 113 September 108 58 166 October 82 68 150 November 68 132 200 2010 793 726 1519 February 131 126 257 March 34 32 66 April 129 42 171 May 117 102 219 June 71 46 117 July 118 50 168 August 16 105 121 September 99 88 187 October 54 68 122 November 24 67 91 Total Result 1570 1462 3032

Year Quarter Month Company Revenue 2009 1 January FirmA 67 2009 1 February FirmA 69 2009 1 March FirmA 128 2009 2 April FirmA 78 2009 2 May FirmA 67 What year had the highest revenu 2009 2 June FirmA 88 What month has the highest reven 2009 3 July FirmA 24 2009 3 August FirmA 65 2009 3 September FirmA 108 2009 4 October FirmA 82 2009 4 November FirmA 68 2009 4 December FirmA 119 2010 1 January FirmA 128 2010 1 February FirmA 131 2010 1 March FirmA 34 2010 2 April FirmA 129 2010 2 May FirmA 117 2010 2 June FirmA 71 2010 3 July FirmA 118 2010 3 August FirmA 16 2010 3 September FirmA 99 2010 4 October FirmA 54 2010 4 November FirmA 24 2010 4 December FirmA 40 2009 1 January FirmB 130 2009 1 February FirmB 50 2009 1 March FirmB 140 2009 2 April FirmB 126 2009 2 May FirmB 17 2009 2 June FirmB 83 2009 3 July FirmB 14 2009 3 August FirmB 48 2009 3 September FirmB 58 2009 4 October FirmB 68 2009 4 November FirmB 132 2009 4 December FirmB 58 2010 1 January FirmB 89 2010 1 February FirmB 126 2010 1 March FirmB 32 2010 2 April FirmB 42 2010 2 May FirmB 102 2010 2 June FirmB 46 2010 3 July FirmB 50 2010 3 August FirmB 105 2010 3 September FirmB 88 2010 4 October FirmB 68 2010 4 November FirmB 67 2010 4 December FirmB 20