public function aroundGetSelectCountSql(
        \Magento\Catalog\Model\ResourceModel\Product\Collection $subject,
        \Closure $proceed
    ) {
        /** @var \Magento\Framework\DB\Select $result */
        $result = $proceed();
        $result->reset(\Zend_Db_Select::GROUP);
        return $result;
    }
public function aroundGetSelectCountSql(
        \Magento\Catalog\Model\ResourceModel\Product\Collection $subject,
        \Closure $proceed
    ) {
        /** @var \Magento\Framework\DB\Select $result */
        $result = $proceed();
        $result->reset(\Zend_Db_Select::GROUP);
        return $result;
    }
public function aroundGetSelectCountSql ( \ Magento \ Catalog \ Model \ ResourceModel \ Product \ Collection $ subject , \ Closure $ proceed ) { /** @var \Magento\Framework\DB\Select $result */ $ result = $ proceed ( ) ; $ result -> reset ( \ Zend_Db_Select :: GROUP ) ; return $ result ; }
Remove group clause to get total count in adminhtml grid.

@param \Magento\Catalog\Model\ResourceModel\Product\Collection $subject
@param \Closure $proceed
@return \Magento\Framework\DB\Select
Remove group clause to get total count in adminhtml grid .