Scribd
Upload
46 views

Practice Sheet - Pivot Table

Uploaded by

nahid.ibrahim.shaikh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
46 views

Practice Sheet - Pivot Table

Uploaded by

nahid.ibrahim.shaikh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Emp_No Emp_Name Designation Salary

E001 Girish Chandra Store Keeper 10000


E002 Anju Malhotra Manager 30000
E003 Manika Batra Executive 26000
E004 Sehaj Bhasin Manager 35000
E005 Atul Kothari Accountant 28000
E006 Saransh Gupta Executive 20000
E007 Devika Goel Senior Manager 51000
E008 Mukul Dev Store Keeper 14000
E009 Neetu Bhatia Manager 32000
E010 Bhoomi Sharma Senior Manager 55000
E011 Nakul Dev Store Keeper 12000
E012 Mishti Shah Accountant 26000
E013 Sanjay Suri Senior Manager 53000
E014 Raj Bhushan Executive 24000
E015 Sarika Devi Executive 24000
Sum of Salary Designation
Emp_Name Accountant Executive Manager Senior Manager Store Keeper
Anju Malhotra 30000
Atul Kothari 28000
Bhoomi Sharma 55000
Devika Goel 51000
Girish Chandra 10000
Manika Batra 26000
Mishti Shah 26000
Mukul Dev 14000
Nakul Dev 12000
Neetu Bhatia 32000
Raj Bhushan 24000
Sanjay Suri 53000
Saransh Gupta 20000
Sarika Devi 24000
Sehaj Bhasin 35000
Total Result 54000 94000 97000 159000 36000
Auditor Property_ID Status
Ajay Solanki M38401095 Correct
Ajay Solanki R38007379 Correct
Ajay Solanki Y37999859 Incorrect
Aakshi Yadav P37897719 Correct
Aakshi Yadav O38404463 Correct
Aakshi Yadav D38399637 Correct
Aakshi Yadav E38071229 Correct
Ajay Solanki Z38200477 Incorrect
Arusi Singh S31944535 Correct
Ajay Solanki A38158805 Correct
Rashmi Gupta D38157051 Correct
Ajay Solanki Q36316107 Correct
Ajay Solanki G38368845 Correct
Arusi Singh U38383699 Incorrect
Rashmi Gupta A37873641 Correct
Ajay Solanki I37659999 Correct
Arusi Singh K38388995 Correct
Status of Property ID
Count of Status Status
Auditor Correct Incorrect Total Result
Aakshi Yadav 4 4
Ajay Solanki 6 2 8
Arusi Singh 2 1 3
Rashmi Gupta 2 2
Total Result 14 3 17
Year Product Sales
2017 Product 9 270
2017 Product 3 200
2017 Product 8 1,150
2017 Product 1 100
2017 Product 7 400
2017 Product 5 510
2017 Product 3 70
2017 Product 6 92
2017 Product 7 350
2017 Product 7 128
2017 Product 7 660
2017 Product 7 276
2017 Product 9 530
2017 Product 1 500
2017 Product 2 2,250
2017 Product 6 150
2017 Product 1 1,000
2017 Product 2 75
2017 Product 6 53
2017 Product 3 97
2017 Product 3 300
2017 Product 4 510
2017 Product 9 1,400
2017 Product 5 3,240
2017 Product 6 105
2017 Product 1 1,930
2018 Product 10 250
2018 Product 9 483
2018 Product 10 1,275
2018 Product 7 1,950
2018 Product 2 13,800
2018 Product 9 35
2018 Product 2 300
2018 Product 5 128
2018 Product 6 1,560
2018 Product 5 184
2018 Product 9 920
2018 Product 2 450
2018 Product 7 920
2018 Product 2 552
2018 Product 10 1,590
2018 Product 3 230
2018 Product 3 300
2018 Product 6 230
2018 Product 6 1,392
2018 Product 10 680
2018 Product 10 200
2018 Product 10 800
2018 Product 1 120
2018 Product 9 220
2018 Product 4 534
2018 Product 6 1,218
2018 Product 1 280
2018 Product 3 456
2018 Product 8 290
2018 Product 9 736
2018 Product 2 13,800
2018 Product 2 900
2018 Product 1 138
2018 Product 8 380
2018 Product 9 122
2018 Product 7 250
2018 Product 8 598
2018 Product 6 4,200
2018 Product 2 1,740

You might also like