When creating the crosstab in the Adhoc view , All the data rows are not being showed as present under table due to crosstab's aggregation behaviour.
Crosstab only shows one single record when converted from Table, We need to show all the records present.
Attaching the screenshot for the reference.
Components | AdHoc |