Table summary row incorrect

[Mingis]

I'm debugging a data issue in Looker Studio: To test something I've built a very simple standard table in a completely fresh report with no other filters, blends or charts, however the summary row in my table does not give the correct sum of the columns e.g. below is showing 209 and 210 but should be 222 and 226 respectively - if I click on 'show underlying data' I can confirm that the columns should add up to 222 and 226:

Does anyone have any ideas what might be causing this? I though it might be something I've missed as part of a bigger more complex report, but I've stripped everything right back to try and debug this issue.

Many thanks.

[GavinW]

I wonder if your metric is doing a count, or a count distinct? 

[Mehdi_Oudjida]

@Mingis 

Your summary makes sense because you are using a connector (GA4 native connector) that returns a level of aggregation for the table rows, and another for the summary. In your case, users are deduplicated for the summary, comparing to the sum of rows. 

So, if the same user came 2 days, it will be counted 1 time in the summary and 2 times for the sum of rows...deduplication...

I hope it helps.

Mehdi

[icgosas]

and how can I make it show me the same value? is there any solution for this?

[ateeqh]

Any solutions to this issue? I am facing the same.