Line list and pivot table do not give the same total

Support - Assistance technique
1

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

1 Like
2

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
3

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.

Screen Shot 2021-07-21 at 11.25.33 AM
Screen Shot 2021-07-21 at 11.25.33 AM1374×855 118 KB

Screen Shot 2021-07-21 at 11.25.47 AM
Screen Shot 2021-07-21 at 11.25.47 AM1362×860 67.3 KB

1 Like
4

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
5

Thanks for the quick response!

1 Like