Sum in a Pivot Table

[neasds]

I cannot understand why the total for the row labels is one in this example:

[TABLE="width: 528"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Sum of Churches[/TD]
[/TR]
[TR]
[TD]Ahoskie[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Aulander Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Beulah baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Cashie Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Center Grove Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Cool Spring Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Earlys Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Greens Cross Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Meherrin Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Ross Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Alamance East[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]BETHEL BAPTIST[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Burlington Assembly of God[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Central Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Deep Creek Baptist[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Ebenezer Church of Christ[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Edgewood Baptist[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]First Church Of The Nazarene[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Glen Hope Baptist [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Ireland Street Chapel[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Kinnett Mem. Bap.[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Kinnett Memorial Baptist[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Lamb's Chapel[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Northside Presbyterian[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Outlet 10:27[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Riverdale Baptist [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Riverside Baptist [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tabernacle Baptist (Mebane)[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Temple Baptist[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Wicker Street Baptist Church[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[SpillerBD]

Switch to Tabular view for the Pivot Table. Row Labels can leave some confusion.
What data is your "Churches" column of the Pivot Tables source?
And what results do you h=get when double clicking any one of the sum numbers and how does that compare to the source data?

 

[neasds]

The Tabular view really helped. Thank you so much.
The total for the location or sum of churches still shows 1 for a total?
The source is members and one of the columns is their church name.