Hi AHMED, how can I help you?
Suggested Questions
Which countries have a population above 100 million?
REPORT
List all completed projects with budget and project lead.
REPORT
What is the count of tasks on time vs tasks late?
REPORT
Show the hierarchy mapping of regions and sub-regions.
REPORT
>
COMPLETED PROJECTS OVERVIEW
TOTAL PROJECTS
9
TOTAL BUDGET
207,000
AVERAGE COST
22,944.44
Report Pivot Chart SQL
Pivot Analysis
NAME SUM OF BUDGET SUM OF COST PROJECT LEAD
Configure Web Environment 5,000 4,750 Bernard Jackman
Develop Bug Application 18,000 16,500 Lucille Beatie
Develop Customer Tracker 14,000 12,000 Lucille Beatie
Develop IT Management Apps 45,000 48,000 Bernard Jackman
Develop New Reporting Apps 15,000 13,000 Lucille Beatie
Implement Customer Satisfaction App 25,000 29,750 Bernard Jackman
Implement Customer Success App 25,000 23,000 Bernard Jackman
Improve IT Management Apps 40,000 38,000 Bernard Jackman
Train Developers 20,000 21,500 Lucille Beatie
BUDGET COST
Chart Types
Column
Stacked
Bar
Line
Area
Pie
Donut
Scatter
Heatmap