Line list and pivot table do not give the same total

Hi all,
Any ideas on why the same event reports table would give different totals when toggling between line list and pivot table on a tracker program? When I have it on line list, it returns 1685 cases, but when I leave all settings exactly the same and switch to pivot table, enrollment, it returns 1549. Trying to understand where the other 136 enrollments are going… Thanks!

Screen Shot 2021-07-21 at 11.05.12 AM

Screen Shot 2021-07-21 at 11.04.59 AM

Screen Shot 2021-07-21 at 11.06.29 AM

Screen Shot 2021-07-21 at 11.06.21 AM

Hey thanks for your question @Natalie_Tibbels! May I ask what is the version of your DHIS2 instance? Thanks! I tried doing the same in DHIS2 version 2.36.3 on play.dhis2.org and the results are different there too!

1 Like

Thank you! I’m on 2.34.5 right now. Here’s the same situation from the play demo site (11 enrollments in line list, 6 in pivot table with otherwise exact same settings). I’m not sure if it’s a feature or a bug that those values would be different.

1 Like

Thanks for reproducing it and for the screenshots @Natalie_Tibbels! I’ve asked for support …

@dusan fixed the bug and this issue is in review process, DHIS2-11524 Line list and pivot table do not give the same total

Thank you @Natalie_Tibbels! :+1:

2 Likes

Thanks for the quick response!

1 Like