I have a cross tab with the correct numbers BUT the percentages are not adding up(I put a summary field under the row count for %) The bottom total line says 100% but the other three for example say 38%, 17%, 44% which equals 99%. I right clicked on it and tried to format it but I didnt have any luck. Maybe it isnt taking into account the decimals??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cross tab percentages dont equal 100%
- Thread starter skijop
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question