Pivot Visualization - pivot values not same as details

Hello everyone, can anyone explain why the value in the cell in the pivot visualization is not the same as the detail data? This happens when I browse the detail data - by clicking on the option on the pivot value.

For example I select the number 283 in the pivot cell (blue square) . But when click detail, the number of rows is not the same (mentioned 294 rows) .

Is there something wrong with my pivot visualization settings?

Hi @afifdevtest
Post "Diagnostic Info" from Admin > Troubleshooting.
And you are using Sum of some field, which is not the same as the amount of rows.

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36 Edg/104.0.1293.70",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.4.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "17.0.4.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.4.1+1",
"os.name": "Windows Server 2016",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2022-07-29",
"tag": "v0.43.4.2",
"branch": "release-x.43.x",
"hash": "7809f82"
},
"settings": {
"report-timezone": null
}
}
}

@afifdevtest Sum of a field doesn't mean the same thing as amount of rows.
Use the Sample Database to provide an example if you don't want to share your data.
Latest release is 0.44.2: https://github.com/metabase/metabase/releases/latest
And you should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2

actually it's using CountIf function , not Sum....
Is that has any difference ?

@afifdevtest You are viewing the pickup_region=value, you are not viewing specific value you clicked on.