| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivots: Grand total = Count not sum of data
Hello,
Thats the question, I have a pivot that I want to count the total number of unblank fields, there are about 10, but it takes the sum and shows like 300 in grand total. I need the grand total to say 10. Is this possible? I need this because of data replication. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivots: Grand total = Count not sum of data
Have you tried right clicking on the Field and selecting Field Settings and
changing the aggregation to Count? -- HTH... Jim Thomlinson "Schwimms" wrote: Hello, Thats the question, I have a pivot that I want to count the total number of unblank fields, there are about 10, but it takes the sum and shows like 300 in grand total. I need the grand total to say 10. Is this possible? I need this because of data replication. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivots: Grand total = Count not sum of data
Yes I change the field setting to count but for some reason its still not
counting it right. It shows like 35, then when I highlight the field with my cursor and show the count its like 11. I have no idea what to do. "Jim Thomlinson" wrote: Have you tried right clicking on the Field and selecting Field Settings and changing the aggregation to Count? -- HTH... Jim Thomlinson "Schwimms" wrote: Hello, Thats the question, I have a pivot that I want to count the total number of unblank fields, there are about 10, but it takes the sum and shows like 300 in grand total. I need the grand total to say 10. Is this possible? I need this because of data replication. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivots: Grand total = Count not sum of data
Double click on the 35 to get a listing of all of the records it is
aggregating (assumes that you have Enable Drill to Detail checked in the Table Options). -- HTH... Jim Thomlinson "Schwimms" wrote: Yes I change the field setting to count but for some reason its still not counting it right. It shows like 35, then when I highlight the field with my cursor and show the count its like 11. I have no idea what to do. "Jim Thomlinson" wrote: Have you tried right clicking on the Field and selecting Field Settings and changing the aggregation to Count? -- HTH... Jim Thomlinson "Schwimms" wrote: Hello, Thats the question, I have a pivot that I want to count the total number of unblank fields, there are about 10, but it takes the sum and shows like 300 in grand total. I need the grand total to say 10. Is this possible? I need this because of data replication. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivots: Grand total = Count not sum of data
It shoots out 35 records but, there are duplicate records that I only want
counted once "Jim Thomlinson" wrote: Double click on the 35 to get a listing of all of the records it is aggregating (assumes that you have Enable Drill to Detail checked in the Table Options). -- HTH... Jim Thomlinson "Schwimms" wrote: Yes I change the field setting to count but for some reason its still not counting it right. It shows like 35, then when I highlight the field with my cursor and show the count its like 11. I have no idea what to do. "Jim Thomlinson" wrote: Have you tried right clicking on the Field and selecting Field Settings and changing the aggregation to Count? -- HTH... Jim Thomlinson "Schwimms" wrote: Hello, Thats the question, I have a pivot that I want to count the total number of unblank fields, there are about 10, but it takes the sum and shows like 300 in grand total. I need the grand total to say 10. Is this possible? I need this because of data replication. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivots: Grand total = Count not sum of data
There's no function in a pivot table that will count unique items. As a
workaround, you could add a field to the source data, to calculate the count, and add that field to the pivot table. There's an example he http://www.contextures.com/xlPivot07.html#Unique Schwimms wrote: It shoots out 35 records but, there are duplicate records that I only want counted once "Jim Thomlinson" wrote: Double click on the 35 to get a listing of all of the records it is aggregating (assumes that you have Enable Drill to Detail checked in the Table Options). -- HTH... Jim Thomlinson "Schwimms" wrote: Yes I change the field setting to count but for some reason its still not counting it right. It shows like 35, then when I highlight the field with my cursor and show the count its like 11. I have no idea what to do. "Jim Thomlinson" wrote: Have you tried right clicking on the Field and selecting Field Settings and changing the aggregation to Count? -- HTH... Jim Thomlinson "Schwimms" wrote: Hello, Thats the question, I have a pivot that I want to count the total number of unblank fields, there are about 10, but it takes the sum and shows like 300 in grand total. I need the grand total to say 10. Is this possible? I need this because of data replication. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Showing the Grand Total on Data Labels | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Hybrid Mode
