How to make Pivot Table out of Wix Database?

Hey Guys, it is been a long time I am using Wix Corvid. And now its time to make great things out of it so I came here.

I was wondering how can we make the Pivot table out of Wix Collection and can be viewed on-site and also a feature to download it for the user in xlsx format . There are certain apps which do this work but they can’t be connected with Wix database. So that’s all my question.

Example of Pivot table - This pivot table has certain things and it is made in Excel and I have marked certain thing and I hope that it is clear. The table shows various vehicles in various colours and where they are present (Area) and how much (values) they are present.

Black - Highlights of the question
Red - Something in the picture

Waiting for your reply!!
Thanks in advance.

Anyone please its urgent at least give me a hint

Hi Guys anyone to help??