Count and Sum data in same Pivot table "robotman[ at ]gmail.com" <robotman[ at ]gmail.com> 29.09.2006 23:56:44 I'm new to pivot tables. I wanted to have one pivot table column that counts the entries in a data column AND another pivot table column that sums the values of the same data column. Excel doesn't seem to let me put more than one copy of the column into the data section of the table. I can change it between count and sum, but i want to show both at the same time. Any ideas? Thanks.

Re: Count and Sum data in same Pivot table Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 30.09.2006 02:45:09 You should be able to drag a second copy of the field from the field list to the pivot table's data area. Make sure that the pointer is over the data area when you drop the field. robotman[ at ]gmail.com wrote: [Quoted Text] > I'm new to pivot tables. > > I wanted to have one pivot table column that counts the entries in a > data column AND another pivot table column that sums the values of the > same data column. Excel doesn't seem to let me put more than one copy > of the column into the data section of the table. I can change it > between count and sum, but i want to show both at the same time. > > Any ideas? > > Thanks. > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html

Re: Count and Sum data in same Pivot table "Epinn" <someone[ at ]example.com.NO_SPAM> 30.09.2006 03:37:42 Hi, Like you, I am new to Pivot Table. After reading your post and Debra's, I explored a bit. As you know, there are two ways we can define the rows and columns. (1) Directly on the new table (skeleton). (2) Via the Layout button. If I go by (1) above, I can only have one column. If I go by (2) above, I can drag the same data field twice. In other words, I can have sum and count in the same table. The layout button can be found via step 3 of the wizard. I don't like the layout right now. I don't have two columns and instead I have sum and count stack up. But I do have the info. I'll do more exploration and see if I can make two columns. Will stay tuned and see if more guidance available. Epinn <robotman[ at ]gmail.com> wrote in message news:1159574204.550524.8570[ at ]e3g2000cwe.googlegroups.com... I'm new to pivot tables. I wanted to have one pivot table column that counts the entries in a data column AND another pivot table column that sums the values of the same data column. Excel doesn't seem to let me put more than one copy of the column into the data section of the table. I can change it between count and sum, but i want to show both at the same time. Any ideas? Thanks.

Re: Count and Sum data in same Pivot table Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 30.09.2006 05:33:40 You can add a field to the data area more than once, either in the worksheet layout, or in the wizard layout. To arrange the data fields horizontally, drag the data button onto the cell that contains the word Total, as shown here: http://www.contextures.com/xlPivot02.html Epinn wrote: [Quoted Text] > Hi, > > Like you, I am new to Pivot Table. After reading your post and Debra's, I explored a bit. > > As you know, there are two ways we can define the rows and columns. > > (1) Directly on the new table (skeleton). > (2) Via the Layout button. > > If I go by (1) above, I can only have one column. > > If I go by (2) above, I can drag the same data field twice. In other words, I can have sum and count in the same table. > > The layout button can be found via step 3 of the wizard. > > I don't like the layout right now. I don't have two columns and instead I have sum and count stack up. But I do have the info. I'll do more exploration and see if I can make two columns. > > Will stay tuned and see if more guidance available. > > Epinn > > <robotman[ at ]gmail.com> wrote in message news:1159574204.550524.8570[ at ]e3g2000cwe.googlegroups.com... > I'm new to pivot tables. > > I wanted to have one pivot table column that counts the entries in a > data column AND another pivot table column that sums the values of the > same data column. Excel doesn't seem to let me put more than one copy > of the column into the data section of the table. I can change it > between count and sum, but i want to show both at the same time. > > Any ideas? > > Thanks. > > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html

Re: Count and Sum data in same Pivot table "Epinn" <someone[ at ]example.com.NO_SPAM> 30.09.2006 07:03:12 Hi Debra, Thanks for your help and I am a happy camper now. I did search for your site prior to posting but I missed it. I have always liked your site because you focus on the popular topics and highlight the important points. For some reason, I always find it easier to add fields via the layout button. Anyway, I can do it both ways now. What happens with the worksheet layout is after I drag the field to the data area, the skeleton disappears instantly giving me the impression that I can't add any more fields. The truth is I just have to "force" the same field into the column. With the layout button, the skeleton remains open until I click okay. Hope this helps robotman. Epinn "Debra Dalgleish" <dsd[ at ]contexturesXSPAM.com> wrote in message news:451E01B4.8020904[ at ]contexturesXSPAM.com... You can add a field to the data area more than once, either in the worksheet layout, or in the wizard layout. To arrange the data fields horizontally, drag the data button onto the cell that contains the word Total, as shown here: http://www.contextures.com/xlPivot02.html Epinn wrote: [Quoted Text] > Hi, > > Like you, I am new to Pivot Table. After reading your post and Debra's, I explored a bit. > > As you know, there are two ways we can define the rows and columns. > > (1) Directly on the new table (skeleton). > (2) Via the Layout button. > > If I go by (1) above, I can only have one column. > > If I go by (2) above, I can drag the same data field twice. In other words, I can have sum and count in the same table. > > The layout button can be found via step 3 of the wizard. > > I don't like the layout right now. I don't have two columns and instead I have sum and count stack up. But I do have the info. I'll do more exploration and see if I can make two columns. > > Will stay tuned and see if more guidance available. > > Epinn > > <robotman[ at ]gmail.com> wrote in message news:1159574204.550524.8570[ at ]e3g2000cwe.googlegroups.com... > I'm new to pivot tables. > > I wanted to have one pivot table column that counts the entries in a > data column AND another pivot table column that sums the values of the > same data column. Excel doesn't seem to let me put more than one copy > of the column into the data section of the table. I can change it > between count and sum, but i want to show both at the same time. > > Any ideas? > > Thanks. > > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html

Re: Count and Sum data in same Pivot table Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 30.09.2006 14:22:12 Instead of watching the outline on the worksheet, watch the shape of the pointer. If it's over an area where you can't drop the field, the pointer is an arrow with a large grey rectangle. If it's over an area where you can drop the field, the pointer is an arrow with a small grey rectangle, and a pivot table outline. In the pointer outline, the blue colour indicates the area in which the field would be dropped. Epinn wrote: [Quoted Text] > Hi Debra, > > Thanks for your help and I am a happy camper now. > > I did search for your site prior to posting but I missed it. I have always liked your site because you focus on the popular topics and highlight the important points. > > For some reason, I always find it easier to add fields via the layout button. Anyway, I can do it both ways now. What happens with the worksheet layout is after I drag the field to the data area, the skeleton disappears instantly giving me the impression that I can't add any more fields. The truth is I just have to "force" the same field into the column. With the layout button, the skeleton remains open until I click okay. > > Hope this helps robotman. > > Epinn > > "Debra Dalgleish" <dsd[ at ]contexturesXSPAM.com> wrote in message news:451E01B4.8020904[ at ]contexturesXSPAM.com... > You can add a field to the data area more than once, either in the > worksheet layout, or in the wizard layout. > > To arrange the data fields horizontally, drag the data button onto the > cell that contains the word Total, as shown here: > > http://www.contextures.com/xlPivot02.html > > Epinn wrote: > >>Hi, >> >>Like you, I am new to Pivot Table. After reading your post and Debra's, I explored a bit. >> >>As you know, there are two ways we can define the rows and columns. >> >>(1) Directly on the new table (skeleton). >>(2) Via the Layout button. >> >>If I go by (1) above, I can only have one column. >> >>If I go by (2) above, I can drag the same data field twice. In other words, I can have sum and count in the same table. >> >>The layout button can be found via step 3 of the wizard. >> >>I don't like the layout right now. I don't have two columns and instead I have sum and count stack up. But I do have the info. I'll do more exploration and see if I can make two columns. >> >>Will stay tuned and see if more guidance available. >> >>Epinn >> >><robotman[ at ]gmail.com> wrote in message news:1159574204.550524.8570[ at ]e3g2000cwe.googlegroups.com... >>I'm new to pivot tables. >> >>I wanted to have one pivot table column that counts the entries in a >>data column AND another pivot table column that sums the values of the >>same data column. Excel doesn't seem to let me put more than one copy >>of the column into the data section of the table. I can change it >>between count and sum, but i want to show both at the same time. >> >>Any ideas? >> >>Thanks. >> >> > > > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html

Re: Count and Sum data in same Pivot table "Epinn" <someone[ at ]example.com.NO_SPAM> 30.09.2006 21:30:32 Thanks. Previously, I did see the blue colour "square" but didn't know what it was. I just discovered something else, a small grey rectangle and a burgundy cross telling me the "NO" zone even though the rectangle is small and grey. This doesn't happen often. Is there a link on your site that talks about all this? Will check and study your PivotTable pages later. Epinn "Debra Dalgleish" <dsd[ at ]contexturesXSPAM.com> wrote in message news:451E7D94.8060403[ at ]contexturesXSPAM.com... Instead of watching the outline on the worksheet, watch the shape of the pointer. If it's over an area where you can't drop the field, the pointer is an arrow with a large grey rectangle. If it's over an area where you can drop the field, the pointer is an arrow with a small grey rectangle, and a pivot table outline. In the pointer outline, the blue colour indicates the area in which the field would be dropped. Epinn wrote: [Quoted Text] > Hi Debra, > > Thanks for your help and I am a happy camper now. > > I did search for your site prior to posting but I missed it. I have always liked your site because you focus on the popular topics and highlight the important points. > > For some reason, I always find it easier to add fields via the layout button. Anyway, I can do it both ways now. What happens with the worksheet layout is after I drag the field to the data area, the skeleton disappears instantly giving me the impression that I can't add any more fields. The truth is I just have to "force" the same field into the column. With the layout button, the skeleton remains open until I click okay. > > Hope this helps robotman. > > Epinn > > "Debra Dalgleish" <dsd[ at ]contexturesXSPAM.com> wrote in message news:451E01B4.8020904[ at ]contexturesXSPAM.com... > You can add a field to the data area more than once, either in the > worksheet layout, or in the wizard layout. > > To arrange the data fields horizontally, drag the data button onto the > cell that contains the word Total, as shown here: > > http://www.contextures.com/xlPivot02.html > > Epinn wrote: > >>Hi, >> >>Like you, I am new to Pivot Table. After reading your post and Debra's, I explored a bit. >> >>As you know, there are two ways we can define the rows and columns. >> >>(1) Directly on the new table (skeleton). >>(2) Via the Layout button. >> >>If I go by (1) above, I can only have one column. >> >>If I go by (2) above, I can drag the same data field twice. In other words, I can have sum and count in the same table. >> >>The layout button can be found via step 3 of the wizard. >> >>I don't like the layout right now. I don't have two columns and instead I have sum and count stack up. But I do have the info. I'll do more exploration and see if I can make two columns. >> >>Will stay tuned and see if more guidance available. >> >>Epinn >> >><robotman[ at ]gmail.com> wrote in message news:1159574204.550524.8570[ at ]e3g2000cwe.googlegroups.com... >>I'm new to pivot tables. >> >>I wanted to have one pivot table column that counts the entries in a >>data column AND another pivot table column that sums the values of the >>same data column. Excel doesn't seem to let me put more than one copy >>of the column into the data section of the table. I can change it >>between count and sum, but i want to show both at the same time. >> >>Any ideas? >> >>Thanks. >> >> > > > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html