Sales Pivot Tables by Product
Budget: $2 – $8 USD
I have a raw sales dataset and need it turned into clear, refreshable Pivot Tables in Excel. Everything should be grouped by product, and each table must display the Sum of sales, Average sales, and Count of sales for every item we sell.
I’ll send the source file (CSV or XLSX) as soon as we start. Please build the solution entirely within Microsoft Excel—no external add-ins are required unless you can demonstrate a tangible benefit.
Deliverables:
• An Excel workbook containing the finished Pivot Table(s)
• All three calculations—Sum, Average, and Count—visible for each product
• Any slicers or simple formatting that improve readability
• A short note or comment sheet explaining how I can refresh the data
If you have samples of similar sales-focused pivot work, feel free to share a screenshot so I can see your style. I’m looking for a quick, clean turnaround and a file I can reuse whenever new sales data comes in.
I’ll send the source file (CSV or XLSX) as soon as we start. Please build the solution entirely within Microsoft Excel—no external add-ins are required unless you can demonstrate a tangible benefit.
Deliverables:
• An Excel workbook containing the finished Pivot Table(s)
• All three calculations—Sum, Average, and Count—visible for each product
• Any slicers or simple formatting that improve readability
• A short note or comment sheet explaining how I can refresh the data
If you have samples of similar sales-focused pivot work, feel free to share a screenshot so I can see your style. I’m looking for a quick, clean turnaround and a file I can reuse whenever new sales data comes in.
Related categories:
Visual Basic
Data Processing
Excel
Microsoft Access
Data Visualization
Data Analysis
Data Modeling
Data Management