I have requirement in which I need count of items and sum of items in the bottom row as mentioned in the image in a straight or pivot table.
But in Single object not in multiple objects.
Please suggest me.
I think you can try to create (let's call it this way) "synthetic dimension". So field call "Total" in your load script. You can make it look like a default Total row by changing the Text format options in both dimensions and expressions.
The way I prefer is to concatenate a template table with 0 values as all of the dimensions. Have a look at the QVW, maybe it will be of any use to you.