Hi SAO,
Based on your requirement, we prepared a sample below that
displays the selected row details using a Pivot table rather than a grid.
Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Pivot_Table2011674072.zip
Moreover, unlike Grid, pivot table currently don't have
built-in "Query" option for filtering the data. so we have
achieved it in sample level.
Output Screenshot :

Please let us know if you have any concerns
With regards,
Rajeshkannah Gopalakrishnan