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:
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.