Composer dashboard cumulative totals

I need to present a dashboard with total count of sales and total amount monthly (row wise) and total count of individual site column wise. How can I achieve this on a pivot table?