excel 2007 pivot data displayed across columns

[meridius10]

I am following instructions from a book that is designed for Excel 2003 but I am now using Excel 2007.

It says "The pivot table would be more aesthetically pleasing if our data were displayed across columns rather than down rows. If we drag the Data button onto the label Total, our data is now displayed across columns rather than down a single row..."

I am not sure how to do this as I can't see the Data button and it is not highlighted in grey as in the book. The book is called Microsoft Excel Data Analysis and Business Modeling (published in 2004) in case any of you have it...

Any ideas?

Country (All) Product (All) Month Data Total January Sum of Var -4297 Sum of Revenue 87534 Sum of Budget 91831 February Sum of Var 2843 Sum of Revenue 90377 Sum of Budget 87534 March Sum of Var -1389 Sum of Revenue 88988 Sum of Budget 90377 April Sum of Var -2774 Sum of Revenue 84982 Sum of Budget 87756 May Sum of Var -423 Sum of Revenue 84559 Sum of Budget 84982 June Sum of Var -548 Sum of Revenue 84011 Sum of Budget 84559 July Sum of Var 2366 Sum of Revenue 86377 Sum of Budget 84011 August Sum of Var -2843 Sum of Revenue 83534 Sum of Budget 86377 September Sum of Var 1389 Sum of Revenue 84923 Sum of Budget 83534 October Sum of Var -4318 Sum of Revenue 80605 Sum of Budget 84923 November Sum of Var 3406 Sum of Revenue 84011 Sum of Budget 80605 December Sum of Var 2366 Sum of Revenue 86377 Sum of Budget 84011 Total Sum of Var -4222 Total Sum of Revenue 1026278 Total Sum of Budget 1030500 <tbody> </tbody>

<tbody>
</tbody>

I think it should look something like this in its final form:

Jan Canada Chip 1 sales Month Product Country Field 32259 April Chip 1 France Sum of Revenue <v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"> <o:lock v:ext="edit" aspectratio="t"> </o:lock></vath></v:stroke></v:shapetype><v:shape style="width: 15pt; height: 53.25pt; margin-top: 0px; margin-left: 24.75pt; visibility: visible; position: absolute; z-index: 1; mso-wrap-style: square; v-text-anchor: top;" id="Line_x0020_7" type="#_x0000_t75" o:spid="_x0000_s19465" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSFdyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJgV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzbmG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsuti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAk0rvJNIBAAAIBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykU8Fu2zAMvQ/oPwi6t46TuE2MOj1kbXfItgLtPoCVZFuYLAmS4iR/P0p2mqwDelh9Is3Hp8cn8fZu3ynSC+el0RXNryaUCM0Ml7qp6K+Xh8sFJT6A5qCMFhU9CE/vVhdfbqFsHNhWMoIM2pdQ0TYEW2aZZ63owF8ZKzTWauM6CJi6JuMOdsjcqWw6mVxnHUhNVyeqrxCAbJ38Dypl2G/B16B78EipWHn+Z9So2OeZodT9o7PP9slF5exH/+SI5BVF5zR0aBHNxsIIwzR719WcCPa16yLe1DXZV3SWT+foDSWHis6XxQzDRCf2gTCsL4qbaUEJw3KxyCcYD6e1Pz/uZ+39RwwocBCCwZk4b6M03f87bb6cX8+OE2+kFuTmbe4j2tsN3oon2qxb0I14bsGKl4NFj/IIxrPQvgGdHDo1oqevu++GIxS2waRHEgWSWkn7LfZ/1rO3iaG0zodHYToSg4oqnCbRQ7/xYdB5hCQ7zINUKtmuNNlVdFngNcSKN0ryWEyJa17XypEeFD6O9I1D/wVzZqt5ImsF8PsxDiAVxiQkt4KT6J8SNJ7WCU6JEritMRrkKZ3c9OlR4mTx3rJ3O5AQ487GRTvPV38AAAD//wMAUEsDBBQABgAIAAAAIQCLZi1ovAYAAOkbAAAaAAAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWzsWU9vHDUUvyPxHay5t9n/zUbdVNnNbgtt2ijZFvXonfHOuPGMR7Y36d5Qe0RCQhTEBYkbBwRUaiUu5dMEiqBI/Qo82zOz4+wsSUoEAppDdubNz+/5/fWzffXaw5ihQyIk5UnPq1+ueYgkPg9oEva8u+PRpXUPSYWTADOekJ43J9K7tvnuO1fxhs9oOuFYBOOIxAQBo0Ru4J4XKZVurK1JH8hYXuYpSeDblIsYK3gV4Vog8BEIiNlao1brrMWYJt4mcFSa0ZDBv0RJTfCZ2NdsCEpwDNLvTKfUJwYbHNQ1Qs7lgAl0iFnPA54BPxqTh8pDDEsFH3pezfx5a5tX1/BGNoipFWNL40bmLxuXDQgOGkamCCeF0Pqo1b2yXfA3AKaWccPhcDCsF/wMAPs+aGrnUubZGq3X+znPEsg+LvMe1Nq1losv8W8uzbnb7/fb3WwulqkB2cfWEn691mltNRy8AVl8ewnf6m8NBh0Hb0AW31nCj650Oy0Xb0ARo8nBElo7dDTKuBeQKWc3KuHrAF+vZfAFCqKhiC4tYsoTtSrWYvyAixEANJBhRROk5imZYh9icoDjiaBYC8AbBJe+WJIvl0haFpK+oKnqee+nOPFKkNcvvn394hl6/eLp8aPnx49+OH78+PjR95aXM/AGTsLywFdff/L7lx+i35599erJZ9V4Wcb//N1HP/34aTUQMmih4cvPn/7y/OnLLz7+9ZsnFfAtgSdl+JjGRKLb5Ajt8Rh0M4ZxZ04m4nwjxhGmzggcAe8K1kMVOcDbc8yqcH3iGu+egOJRBbw+e+DMdT8SM0UrJN+MYge4wznrc1FpgJtaVsnC41kSVgsXszJuD+PDKtkDnDiuHc5SqJp5UDq2H0TEmeYuw4nCIUmIQvobPyCkQrv7lDp23aG+4JJPFbpPUR/TSpOM6cQJpMWgGzQGv8yrdAZXO7bZuYf6nFVpvU0OXSQkBGYVkx8T5pjxOp4pHFexHOOYlQ1+C6uoapL7c+GXcUOpwNMhYRwNAyJl1Zg7AvQtOf0mhnpV6fYdNo9dpFD0oIrnLcx5GbnNDwYRjtMq7D5NojL2PXkAIYrRLldV8B3uZoh+Bz/gZKW771HiuPv0QnCXhs6UFgGiv8yE9iUUaqf+xjT5s2LMKFRjGwNvi3HP24KlqSolbpwowatw/8LCu41nyS6BWF9eeN7W3bd11/vP191VuXzWarsosFB7dfNg+2LTJccrm+QpZWxfzRm5JU2fLGGxCEZA1OPMZpAUm6Y0gsesuDu4UGAzBgmuPqAq2o9wCj123dNMQpmxDiVKuYS9nSFX8tZ46NOV3Rm29Z7B1gOJ1Q4PLLmpyfnWoGBjlpzQ7D9zQU3N4KzCmlcypqD2mwir60mdWVrdTM2UOkdaoTL4cFk1IBbWhC4EQe8CVu7AdlyLhr0JZiTQdrcLcO4W44WLdJGMcEAyH2m9l31UN07KY8UcBkDsVPhI7/NOsVpJWlez/QvSzuKksrjWCnG59/6Kl/IIXnhJ5+2JdGRJOTlZgo56XrfdaHvIx2nPm8K2Fh7jFLwudeOHWQgHQr4SNuxPTWaT5QtvdnPF3CSow0mFtfuSwk4dSIVU21hGNjTMpywEWKIl2fk32mDWi1LARvobzKK5DsHwj80C7Oi6lkynxFdlZ5co2nb2NSulfKaI2I+CIzRhM7GHwf06VEGfgEo4nTAVQb/AUZq2tvnkFucs6coHWAZn6ZilEc7KrU7RPJMt3ORxMQfzVpoe6FY5d6Pc+VUxKX9BqpTD+H+mil5P4LigGWgP+HAuKzDS+drzuFARhyqURtQfCWgcTO2AaIHjWPgMQQWHyOZXkEP9a3PO8jBpDbs+tUdDJCisRyoShOxCWTLRdwqzerZ2WZYsY2QiqjRdmdppT8ghYWNdAzt6bfdQBKFuqklWBgzuZPy571kGTULd5JTzzakhxdprc+Dv7nxsMoNSbh02DU1u/2KKFauqHW+G52tvWRH9YdFmtfKsAGGlpaCbpf0bTuGcS62tWEsaN9r55MCLyxoDsWiIUjj0QfofrH9U+MxeOOgFdcz3oLYiuGvQzCBsIKov2cYD6QJpiRNonCzRBpNmZU2btU7aavlifcGdbiH3hLH1zM7i73Mau2jOXHFOLl6ksTMLO7a2tJWmBs+eTFEgTfONjHFM1cXTDk7RJKz3PLj8AUc/hCe4PvKA1tC0hqbBE9wJQbNkL3J6XvaQU+C7pRSYZk5p5phWTmnllHZOgeYsuzLJKR2oVPqWA27Z9I+H8gsN6OCyC5C8qDq3c5t/AAAA//8DAFBLAwQUAAYACAAAACEAnGZGQbsAAAAkAQAAKgAAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc4SPzQrCMBCE74LvEPZu0noQkSa9iNCr1AcIyTYtNj8kUezbG+hFQfCyMLPsN7NN+7IzeWJMk3ccaloBQae8npzhcOsvuyOQlKXTcvYOOSyYoBXbTXPFWeZylMYpJFIoLnEYcw4nxpIa0cpEfUBXNoOPVuYio2FBqrs0yPZVdWDxkwHii0k6zSF2ugbSL6Ek/2f7YZgUnr16WHT5RwTLpRcWoIwGMwdKV2edNS1dgYmGff0m3gAAAP//AwBQSwECLQAUAAYACAAAACEAu+VIlAUBAAAeAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAADYBAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQCTSu8k0gEAAAgEAAAfAAAAAAAAAAAAAAAAACACAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAItmLWi8BgAA6RsAABoAAAAAAAAAAAAAAAAALwQAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAGAAgAAAAhAJxmRkG7AAAAJAEAACoAAAAAAAAAAAAAAAAAIwsAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc1BLBQYAAAAABQAFAGcBAAAmDAAAAAA=" o:insetmode="auto"> <v:imagedata o:title="" src="file:///C:\Users\DREAML~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"> <o:lock v:ext="edit" aspectratio="f"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:cf>Bitmap</x:cf> <x:autopict> </x:autopict></x:sizewithcells></x:clientdata> </o:lock></v:imagedata></v:shape><v:shape style="width: 165pt; height: 121.5pt; margin-top: 7.5pt; margin-left: 26.25pt; visibility: visible; position: absolute; z-index: 2; mso-wrap-style: square; v-text-anchor: top;" id="Line_x0020_8" type="#_x0000_t75" o:spid="_x0000_s19466" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSFdyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJgV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzbmG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsuti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAnxpgYtIBAAARBAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysU8Fu2zAMvQ/YPwi6r3bSJEuNKj1kbXfI1gLtPoCVZFuYLAmS4iR/P0p2mqwDNmCbT5T5+Pj4JF7f7DtNeumDsobRyUVJiTTcCmUaRr89331YUhIiGAHaGsnoQQZ6s3r/7hqqxoNrFSfIYEIFjLYxuqooAm9lB+HCOmkwV1vfQcSjbwrhYYfMnS6mZbkoOlCGrk5UnyAC2Xr1F1Ta8u9SrMH0EJBS8+r8z6hR839nhsr09949uUeflPOv/aMnSjCKzhno0CJajIkRhsfiTVVzItjXvkt4W9dkz+jlZHY5nSPXgdFFWZYf5wOd3EfCMY++lTnPEYDY5fSI4O3D7yl4e/sHEpQ5yMHgTGJwSaDpf515cjVbzI5zb5SRZPk6/REd3AbvJhBj1y2YRj614OTzwaFTkwTGXmjigM4+nQrR2ZfdFysQCtto81NJAkmtlfuc6v+Dc69DQ+V8iPfSdiQFjGocKHeAfhPiIPUIyY7YO6V1vm1tyI7Rq/l0nguC1UqkZIIF37ystSc9aHwl+Rvn/gnm7daITNZKELdjHEFpjEnMhkWv0EItaerWSUGJlri2KRrkaZMNDfl14mTp6oo3y5AR4/KmjTs/r34AAAD//wMAUEsDBBQABgAIAAAAIQCLZi1ovAYAAOkbAAAaAAAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWzsWU9vHDUUvyPxHay5t9n/zUbdVNnNbgtt2ijZFvXonfHOuPGMR7Y36d5Qe0RCQhTEBYkbBwRUaiUu5dMEiqBI/Qo82zOz4+wsSUoEAppDdubNz+/5/fWzffXaw5ihQyIk5UnPq1+ueYgkPg9oEva8u+PRpXUPSYWTADOekJ43J9K7tvnuO1fxhs9oOuFYBOOIxAQBo0Ru4J4XKZVurK1JH8hYXuYpSeDblIsYK3gV4Vog8BEIiNlao1brrMWYJt4mcFSa0ZDBv0RJTfCZ2NdsCEpwDNLvTKfUJwYbHNQ1Qs7lgAl0iFnPA54BPxqTh8pDDEsFH3pezfx5a5tX1/BGNoipFWNL40bmLxuXDQgOGkamCCeF0Pqo1b2yXfA3AKaWccPhcDCsF/wMAPs+aGrnUubZGq3X+znPEsg+LvMe1Nq1losv8W8uzbnb7/fb3WwulqkB2cfWEn691mltNRy8AVl8ewnf6m8NBh0Hb0AW31nCj650Oy0Xb0ARo8nBElo7dDTKuBeQKWc3KuHrAF+vZfAFCqKhiC4tYsoTtSrWYvyAixEANJBhRROk5imZYh9icoDjiaBYC8AbBJe+WJIvl0haFpK+oKnqee+nOPFKkNcvvn394hl6/eLp8aPnx49+OH78+PjR95aXM/AGTsLywFdff/L7lx+i35599erJZ9V4Wcb//N1HP/34aTUQMmih4cvPn/7y/OnLLz7+9ZsnFfAtgSdl+JjGRKLb5Ajt8Rh0M4ZxZ04m4nwjxhGmzggcAe8K1kMVOcDbc8yqcH3iGu+egOJRBbw+e+DMdT8SM0UrJN+MYge4wznrc1FpgJtaVsnC41kSVgsXszJuD+PDKtkDnDiuHc5SqJp5UDq2H0TEmeYuw4nCIUmIQvobPyCkQrv7lDp23aG+4JJPFbpPUR/TSpOM6cQJpMWgGzQGv8yrdAZXO7bZuYf6nFVpvU0OXSQkBGYVkx8T5pjxOp4pHFexHOOYlQ1+C6uoapL7c+GXcUOpwNMhYRwNAyJl1Zg7AvQtOf0mhnpV6fYdNo9dpFD0oIrnLcx5GbnNDwYRjtMq7D5NojL2PXkAIYrRLldV8B3uZoh+Bz/gZKW771HiuPv0QnCXhs6UFgGiv8yE9iUUaqf+xjT5s2LMKFRjGwNvi3HP24KlqSolbpwowatw/8LCu41nyS6BWF9eeN7W3bd11/vP191VuXzWarsosFB7dfNg+2LTJccrm+QpZWxfzRm5JU2fLGGxCEZA1OPMZpAUm6Y0gsesuDu4UGAzBgmuPqAq2o9wCj123dNMQpmxDiVKuYS9nSFX8tZ46NOV3Rm29Z7B1gOJ1Q4PLLmpyfnWoGBjlpzQ7D9zQU3N4KzCmlcypqD2mwir60mdWVrdTM2UOkdaoTL4cFk1IBbWhC4EQe8CVu7AdlyLhr0JZiTQdrcLcO4W44WLdJGMcEAyH2m9l31UN07KY8UcBkDsVPhI7/NOsVpJWlez/QvSzuKksrjWCnG59/6Kl/IIXnhJ5+2JdGRJOTlZgo56XrfdaHvIx2nPm8K2Fh7jFLwudeOHWQgHQr4SNuxPTWaT5QtvdnPF3CSow0mFtfuSwk4dSIVU21hGNjTMpywEWKIl2fk32mDWi1LARvobzKK5DsHwj80C7Oi6lkynxFdlZ5co2nb2NSulfKaI2I+CIzRhM7GHwf06VEGfgEo4nTAVQb/AUZq2tvnkFucs6coHWAZn6ZilEc7KrU7RPJMt3ORxMQfzVpoe6FY5d6Pc+VUxKX9BqpTD+H+mil5P4LigGWgP+HAuKzDS+drzuFARhyqURtQfCWgcTO2AaIHjWPgMQQWHyOZXkEP9a3PO8jBpDbs+tUdDJCisRyoShOxCWTLRdwqzerZ2WZYsY2QiqjRdmdppT8ghYWNdAzt6bfdQBKFuqklWBgzuZPy571kGTULd5JTzzakhxdprc+Dv7nxsMoNSbh02DU1u/2KKFauqHW+G52tvWRH9YdFmtfKsAGGlpaCbpf0bTuGcS62tWEsaN9r55MCLyxoDsWiIUjj0QfofrH9U+MxeOOgFdcz3oLYiuGvQzCBsIKov2cYD6QJpiRNonCzRBpNmZU2btU7aavlifcGdbiH3hLH1zM7i73Mau2jOXHFOLl6ksTMLO7a2tJWmBs+eTFEgTfONjHFM1cXTDk7RJKz3PLj8AUc/hCe4PvKA1tC0hqbBE9wJQbNkL3J6XvaQU+C7pRSYZk5p5phWTmnllHZOgeYsuzLJKR2oVPqWA27Z9I+H8gsN6OCyC5C8qDq3c5t/AAAA//8DAFBLAwQUAAYACAAAACEAnGZGQbsAAAAkAQAAKgAAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc4SPzQrCMBCE74LvEPZu0noQkSa9iNCr1AcIyTYtNj8kUezbG+hFQfCyMLPsN7NN+7IzeWJMk3ccaloBQae8npzhcOsvuyOQlKXTcvYOOSyYoBXbTXPFWeZylMYpJFIoLnEYcw4nxpIa0cpEfUBXNoOPVuYio2FBqrs0yPZVdWDxkwHii0k6zSF2ugbSL6Ek/2f7YZgUnr16WHT5RwTLpRcWoIwGMwdKV2edNS1dgYmGff0m3gAAAP//AwBQSwECLQAUAAYACAAAACEAu+VIlAUBAAAeAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAADYBAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQCfGmBi0gEAABEEAAAfAAAAAAAAAAAAAAAAACACAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAItmLWi8BgAA6RsAABoAAAAAAAAAAAAAAAAALwQAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAGAAgAAAAhAJxmRkG7AAAAJAEAACoAAAAAAAAAAAAAAAAAIwsAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc1BLBQYAAAAABQAFAGcBAAAmDAAAAAA=" o:insetmode="auto"> <v:imagedata o:title="" src="file:///C:\Users\DREAML~1\AppData\Local\Temp\msohtmlclip1\01\clip_image002.png"> <o:lock v:ext="edit" aspectratio="f"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:cf>Bitmap</x:cf> <x:autopict> </x:autopict></x:sizewithcells></x:clientdata> </o:lock></v:imagedata></v:shape> <tbody> </tbody> 37600 Data Product Country Month Sum of Var Sum of Revenue Sum of Budget % age of revenue Sum of Var % of Budegt Chip 1 Canada January 2929 32259 29330 3.14% 0.099863621 April 1054 20343 19289 1.98% 0.054642542 July -5114 22930 28044 2.23% -0.182356297 October 1454 29330 27876 2.86% 0.052159564 Canada Total 323 104862 104539 10.22% 0.003089756 France January -5772 27399 33171 2.67% -0.174007416 April -54 37600 37654 3.66% -0.001434111 July -275 27239 27514 2.65% -0.009994912 October -1917 27300 29217 2.66% -0.065612486 France Total -8018 119538 127556 11.65% -0.062858666 US January -1454 27876 29330 2.72% -0.049573815 April -3774 27039 30813 2.63% -0.122480771 July 7755 36208 28453 3.53% 0.272554739 October -3855 23975 27830 2.34% -0.138519583 US Total -1328 115098 116426 11.22% -0.011406387 Chip 1 Total -9023 339498 348521 33.08% -0.025889401 Chip 2 Canada February 3318 35363 32045 3.45% 0.103541894 May 8332 28675 20343 2.79% 0.409575775 August -3855 23975 27830 2.34% -0.138519583 November 2929 32259 29330 3.14% 0.099863621 Canada Total 10724 120272 109548 11.72% 0.097893161 France February -3846 29108 32954 2.84% -0.116708139 May 3318 35363 32045 3.45% 0.103541894 August 2769 33432 30663 3.26% 0.090304276 November 0 23876 23876 2.33% 0 France Total 2241 121779 119538 11.87% 0.018747177 US February 3371 25906 22535 2.52% 0.149589527 May -12073 20521 32594 2.00% -0.370405596 August -1757 26127 27884 2.55% -0.063011046 November 477 27876 27399 2.72% 0.017409395 <tbody> </tbody>

<tbody>
</tbody>

<tbody>
</tbody>

 

[Jerry Sullivan]

If I'm understanding your source data organization, to make the layout shown in your second image you would start by:

1. In the Pivot Field List pane, drag the fields Var, Revenue and Budget into the Values area of the PivotTable Report.

2. Those fields should default to summary by "Sum of..."; however if any of them default to "Count of...", then Click on the field name in the Values area > Value Field Settings.... > Summarize Values by > Sum.

 

[meridius10]

If I'm understanding your source data organization, to make the layout shown in your second image you would start by:

1. In the Pivot Field List pane, drag the fields Var, Revenue and Budget into the Values area of the PivotTable Report.

2. Those fields should default to summary by "Sum of..."; however if any of them default to "Count of...", then Click on the field name in the Values area > Value Field Settings.... > Summarize Values by > Sum.

Thanks! It was dragging to "Values" that solved this problem.