excel 2007 pivot data displayed across columns

meridius10

New Member
Joined
Apr 30, 2011
Messages
47
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" o:preferrelative="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> <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"> <o:lock v:ext="edit" aspectratio="t"> </o:lock></v:path></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>
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Jerry Sullivan

MrExcel MVP
Joined
Mar 18, 2010
Messages
8,787
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

New Member
Joined
Apr 30, 2011
Messages
47
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,608
Messages
5,597,143
Members
414,129
Latest member
mr vba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top