Pivot report help

Craig2010 · Mar 20, 2010

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CSHIFTM%7E1.PAL%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5CSHIFTM%7E1.PAL%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5CSHIFTM%7E1.PAL%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0cm; margin-right:0cm; margin-bottom:10.0pt; margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> [FONT=&quot]Hi All,
I have been grinding away trying to make this sheet work. Finally figured out how to enter data with a User Form and now looking for a way to generate reports. The data gets entered into a very simple spreadsheet as you can see at the bottom. When I run a pivot report filtering by each player I want to get totals for a given month without seeing each individual days entries for the given month(See Below). Is this possible? I would also like to be able run different reports that would want a similar set up by giving me totals for a month with showing each "Player" which would be a similar custom type filtering? Is there also a way to sort the information in a list automatically from say highest to lowest?
Any help would be appreciated.[/FONT]

<table style="border-collapse: collapse; width: 432pt;" width="575" border="0" cellpadding="0" cellspacing="0"><col style="width: 109pt;" width="145"> <col style="width: 188pt;" width="250"> <col style="width: 135pt;" width="180"> <tbody><tr style="height: 21.75pt;" height="29"> <td class="xl70" style="height: 21.75pt; width: 109pt;" width="145" height="29">Player</td> <td class="xl69" style="width: 188pt; font-size: 14pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="250">Tom</td> <td class="xl66" style="width: 135pt;" width="180"> </td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl67" style="height: 24.95pt;" height="33"> </td> <td class="xl65">
</td> <td class="xl68"> </td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl76" style="height: 24.95pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="33"> </td> <td class="xl77" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">Values</td> <td class="xl78" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);"> </td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl71" style="height: 24.95pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 1pt 1pt; border-style: none none solid solid; border-color: -moz-use-text-color -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="33">Row Labels</td> <td class="xl73" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; background: none repeat scroll 0% 0% rgb(219, 229, 241);">Sum of Buy-In</td> <td class="xl72" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">Sum of Win/Loss</td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl80" style="height: 24.95pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext;" height="33">19/03/2010</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">100,000</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">(40,000)</td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl80" style="height: 24.95pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext;" height="33">19/01/2010</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">50,000</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">(20,000)</td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl80" style="height: 24.95pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext;" height="33">12/02/2010</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">80,000</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">(20,000)</td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl80" style="height: 24.95pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext;" height="33">12/03/2010</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">100,000</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">(40,000)</td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl80" style="height: 24.95pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext;" height="33">13/03/2010</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">140,000</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">(80,000)</td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl80" style="height: 24.95pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext;" height="33">5/03/2010</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">20,000</td> <td class="xl79" style="border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color;">40,000</td> </tr> <tr style="height: 24.95pt;" height="33"> <td class="xl74" style="height: 24.95pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 1pt 1pt 2pt; border-style: solid solid double; border-color: windowtext; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="33">Grand Total</td> <td class="xl75" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 1pt 1pt 2pt medium; border-style: solid solid double none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">490,000</td> <td class="xl75" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 1pt 1pt 2pt medium; border-style: solid solid double none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">(160,000)</td> </tr> </tbody></table>

[FONT=&quot]<o

></o

>[/FONT]
<table class="MsoNormalTable" style="border-collapse: collapse; width: 335pt;" width="447" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 18.75pt;"> <td style="width: 67pt; padding: 0cm; height: 18.75pt;" width="89"> [FONT=&quot]Player<o

></o

>[/FONT]
</td> <td style="width: 67pt; padding: 0cm; height: 18.75pt;" width="89"> [FONT=&quot]Date<o

></o

>[/FONT]
</td> <td style="width: 67pt; padding: 0cm; height: 18.75pt;" width="89"> [FONT=&quot]Buy-In<o

></o

>[/FONT]
</td> <td style="width: 67pt; padding: 0cm; height: 18.75pt;" width="89"> [FONT=&quot]Cash Out<o

></o

>[/FONT]
</td> <td style="width: 67pt; padding: 0cm; height: 18.75pt;" width="89"> [FONT=&quot]Win/Loss<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Tom<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]19-Jan-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]50,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]30,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](20,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]****<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]20,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]10,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](10,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Harry<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]1-Jan-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]23,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]17,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](6,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Jane<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]23-Jan-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]15,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](10,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Jill<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]15-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]10,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]12,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]2,000<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]****<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]1,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](4,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]****<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]20,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]10,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](10,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]****<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]19-Mar-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]20,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]30,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]10,000<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Harry<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]2-Jan-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]23,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]17,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](6,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Harry<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]3-Jan-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]13,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]17,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]4,000<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Harry<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]4-Jan-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]23,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]17,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](6,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Jane<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]23-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]15,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](10,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Jane<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]25-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]6,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]1,000<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Jane<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]27-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]7,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](2,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Jane<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]1-Mar-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]9,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](4,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Tom<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]12-Feb-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]40,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]30,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](10,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Tom<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]12-Mar-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]50,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]30,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](20,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Tom<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]13-Mar-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]70,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]30,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot](40,000)[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Tom<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5-Mar-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]10,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]30,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]20,000<o

></o

>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]Tom<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]19-Mar-10<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]5,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]30,000<o

></o

>[/FONT]
</td> <td style="padding: 0cm; height: 15pt;"> [FONT=&quot]25,000<o

></o

>[/FONT]
</td> </tr> </tbody></table> <input id="gwProxy" type="hidden"><input *******="jsCall();" id="jsProxy" type="hidden">

CHC Consulting LLC · Mar 20, 2010

Sorting in a Pivot Table

Grouping in a Pivot Table

Check these short videos out, they should help.

Craig2010 · Mar 20, 2010

Thanks for that...The videos were excellent and show in an easy way exactly what I wanted to do. It's an excellent site and straight to bookmarks.
<input id="gwProxy" type="hidden"><input *******="jsCall();" id="jsProxy" type="hidden">

Pivot report help

Craig2010

New Member

Excel Facts

CHC Consulting LLC

Active Member

Craig2010

New Member

Similar threads

Forum statistics

Share this page

Pivot report help

Craig2010

New Member

Excel Facts

CHC Consulting LLC

Active Member

Craig2010

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock