I am trying to create a view where the breakdown will have the sum of all rows. Please see the figure below:
How can I do sum of rows ?
if you are using a table card, just go to the Chart Properties and select Show Total Row.
Here is a link to the KB article that tells you all the things you can do.
I am using a Pivot table.
The Pivot Table card has a chart property called Totals and you can select Show Total Rows as well as Show Total Columns.