Jul 03 2019 12:03 PM
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??
Jul 03 2019 12:36 PM
Hi
Can 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.
Thanks
Nabil Mourad
Jul 03 2019 12:43 PM
Jul 03 2019 01:04 PM
Jul 03 2019 01:49 PM
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.
I do not prefer to provide an answer without a sample data in Excel to be more accurate!
Thanks
Nabil Mourad
Jul 03 2019 01:54 PM
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.
Jul 03 2019 01:55 PM
The sample within text is copy/pasted from Excel file. If you copy/paste it back from post to Excel file you'll see extra spaces.