1. Regional Product Revenue Breakdown
Sales Operations AnalystBackground
An analyst has raw monthly transaction logs containing region, product line, and sales amounts.
Problem
Need a summarized matrix showing total sales for each product by region, complete with row and column totals.
How to use
Paste transaction CSV records, set Row Dimension to 'region', Column Dimension to 'product', Value Column to 'sales', and choose 'sum' aggregation.
rowDimension: region, columnDimension: product, valueColumn: sales, aggregateFunction: sum, includeRowTotals: true, includeColumnTotals: true, outputFormat: tableOutcome
A structured pivot table displaying summed sales figures across all region-product pairs with row, column, and grand totals.