I am having an issue with SPSS not correctly reporting the correct unweighted base for a weighted table. Here are the unweighted numbers. Any one else having this issue?

When I weight by the age cohorts the total column reflects the correct weighted mean but the incorrect unweighted base. For example, the base for the total column should be 61. Is there a different custom table statistic that I should use to report the unweighted base? I also don't understand why the bases for the other age columns are off. I have tried the other count /base statistics but none matches the correct unweighted base. Unweighted counts reflect the counts for the full data set and not the reduced base for this question (which is what should show)


Thanks in advance. Hoping there is a simple fix.
------------------------------
Ratna Wynn
------------------------------