Duplicate groups in pivot table

Question

I have a simple table with three groups, and I'm trying to tally how many males vs females. I'm getting the following:

Count of Subject ID	Column Labels
Row Labels	INR	R	Z	Grand Total
F	2	6		8
F	1			1
M	22	16	3	41
M	2		1	3
Grand Total	27	22	4	53

I've done a find and replace on "M" and "F", but I'm still getting this separation. Any idea why??

nabilmourad · Answer

janaki223&nbsp;HiCan you share a sample of data before pivoting in an excel file, to see the different columns in the source list and accordingly create the pivot table with 2 levels in the Row area then create Subtotals.ThanksNabil Mourad

detlef_lewin · Answer

janaki223&nbsp;There might be some additional spaces behind some F and M.&nbsp;

sergeibaklan · Answer

Detlef_Lewin&nbsp;
Exactly, second F and M are with spaces at the end - "F " and "M "

nabilmourad · Answer

janaki223&nbsp;The assumption that there is a space may be correct for the "F" , however for the "M" there is a value in the 2 rows.&nbsp;I do not prefer to provide an answer without a sample data in Excel to be more accurate!ThanksNabil Mourad

janaki223 · Answer

It did, in fact, turn out to be a trailing space causing the problem. I thought I had done a correct global replacement, but even doing that, I ended up finding the individual rows causing the problems from the Pivot Table, and correcting the trailing space.

Thanks for the quick replies.

Forum Discussion

Duplicate groups in pivot table

6 Replies

Resources