I am trying to add a custom column in my custom grid in the admin panel. To add the custom column, I have used LEFT JOIN and GROUP BY in the collection which I get from the parent grid class.
After using JOIN and GROUP BY clauses, I am able to add the custom column in my grid, but the issue is that the GRID is now showing the wrong count of records always.
It is always showing 1 as count.
I have added the same column in another grid and it is working fine.
Note: I am not using UI component. Since the grid is coming from an extension's block files, I am using block PHP file to add my custom column.