Row data missing

[hongyu]

Hi

I'm facing some strange issue.

Looking at table in data. three entries from 7 Jul 2022 is missing in report. I had include all data from Jul below.

And this is the total amout I have in Report

Only applied with below filters which should not impact on calculation.

However, if I manual change the date to 17 Jul 2022 as below shown. All numbers are able to shown in report.

I do not want to change the date. And can someone please help me to resolve this issue?

[hongyu]

Thank you. Managed to resolve it.

[vanessafvg]

please can you share how you solved it and then set it to the solution so this thread can be closed thank you. 

[vanessafvg]

are you able to share your file at all?  its quite difficult to figure it out with the screenshots as there is obviously something going on but it wont be obvious in what you have provided.

[hongyu · Accepted solution]

Actually my date table was not covering the data's date. I changed dynamic date range to cover the data's date.

Hence, this issue resolved.