How to display data like this in Straight table or in Pivot Table?

[whitestonek]

I want to display data in Group wise total in either Pivot Table or in Straight Table.

Can you please suggest me to how to implement to display output on this below screenshot.

[timpoismans]

Hi Satish

Best to use a Pivot Table to achieve this result:

Total is on the dimension [Vehicle Number].

Mind, this is made in Qlik Sense, but the same should be possible for QlikView.