Pivot table and AppSheet

[Ste1]

Hi,
I would like to use pivot table capabilities and then display the results in the app with AppSheet.
Would that be possible?
I have tried to create sorting and filtering rules that would mimic the pivot table’s behaviour, but no success with some more complex cases.
I have looked through the topics and found some comments on that question in this post:

help.appsheet.com

Using Spreadsheets with Pivoted Data

Most spreadsheet data uses field names as column headers and data entries in each row.

Example:
A bunch of users are using a group of cars; I would like to know how long in hh:mm each car have been used by which user (columns are car types and lines user ID). I could not create a good enough filter with appsheet whereas it was quite easy with a pivot table.

I have more complex examples if needed.

Thank you!
Steven