Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
KuntalSingh
Helper V
Helper V

Daily work allocation

Hi All

 

Need help to allocate the daily work in the team. Coditions are Bulk verndors are equally distributed in the team and rest all are distributed equally. Emp attendance are in Team tab and raw dump is in dump tab.

Please find below sample data

Document IdCurrent AgentVerdorGross invoice amount
2000994034 A J CONSTRUCTIONS47984
2000994029 A J CONSTRUCTIONS17808
2000994032 A J CONSTRUCTIONS8296
2000994025 A J CONSTRUCTIONS11741
2000964456 A SQUARE SYSTEMS44446.5
2000955457 A.B. ELECTRICALS24572
2000938765 A.M. BESTON SUPPLIERS1872509.43
2000944262 A.S MECHANICAL SYSTEMS PVT LTD23777
2000982374 A.S.FABRICATION85495.94
2000951554 AAKAAR FABRITECH881019.17
2000954287 AARCS PROJECTS56055.86
2000950071 AASHIRWAD ENGINEERS24970
2000972591 ACCUMAX INSTRUMENTS PRIVATE LIMITED73190
2000890693 ADARSH ELECTRIC WORKS2053924.1
2000969932 ADARSH SHARMA22000
2000972573 ADHYA HSE SOLUTIONS13806
2000972574 ADHYA HSE SOLUTIONS11800
2000946165 ADITYA ENTERPRISES13891.49
2000946166 ADITYA ENTERPRISES15359.62
2000946170 ADITYA ENTERPRISES2343.35
2000946171 ADITYA ENTERPRISES5995.96
2000946176 ADITYA ENTERPRISES18803.48
2000946169 ADITYA ENTERPRISES10067.36
2000946168 ADITYA ENTERPRISES26978.6
2000946167 ADITYA ENTERPRISES2640.52
2000996121 ADITYA INFOTECH8142
2000954227 AGARWAL ASSOCIATES21364
2000969375 AGGARWAL GENERAL STORE4960
2000972616 AHA OILFIELD SERVICES67700
2000959001 AJAY AIR PRODUCTS (P) LTD46020
2000940009 AKG ENTERPRISES19824
2000763384 AKS ENGINEERS22656
2000968330 AKSHAR PRECISION TUBES PVT. LTD527460
2000982713 ALETHE CONSULTING PRIVATE LIMITED159841
2000992626 ALFA LAVAL INDIA PRIVATE LIMITED378451
2000886008 AMBUJAM890872
2000886006 AMBUJAM797467
2000886009 AMBUJAM839671
2000997194 AMI CYLINDERS262379.57
2000969928 AMIR GAS APPLIANCES PRIVATE LTD300404.4
2000966592 ANANT ENTERPRISES182780
2000966654 ANANT ENTERPRISES96626.52
2000967091 ANIKETH ENGINEERING529229.42
2000953991 ANIKETH ENGINEERING264614.7
2000985921 ANKIT STATIONERY20410
2000985288 ANKITA ENTERPRISES97645
2000984945 ANKITA ENTERPRISES74340
2000997398 ANTON PAAR INDIA PVT. LTD.64900.02
2000997394 ANTON PAAR INDIA PVT. LTD.64900.02
2000974231 ANUJ ENGINEERING CO.2841118.26
2000911463 ARK SAFETY TOOLS942
2000444128 ARORA AND COMPANY16923.15
2000977210 ARORA AND COMPANY528959.78
2000990506 ARORA TRADING CORPORATION1910
2000990505 ARORA TRADING CORPORATION4236
2000990503 ARORA TRADING CORPORATION8675
2000973528 ARVIND KUMAR213407.72
2000990222 AS EQUIPMENT PRIVATE LIMITED14389
2000957398 ASCENT ELECTRIFICATION ENGINEERS902333
2001000889 ASHWANI KUMAR1359620.78
2000687021 ASHWANI MARWAH CIVIL ENGINEER73986
2000985537 ATISARV HOSPITALITY LLP78444
2000883313 ATLAS COPCO INDIA LIMITED614804.01
2000992637 ATLAS COPCO INDIA LIMITED3549982.8
2000883307 ATLAS COPCO INDIA LIMITED204934.67
2000746843 ATOS INDIA PRIVATE LIMITED6315.12
2000746841 ATOS INDIA PRIVATE LIMITED6315.12
2000746846 ATOS INDIA PRIVATE LIMITED40059.35
2000746840 ATOS INDIA PRIVATE LIMITED73213.93
2000746880 ATOS INDIA PRIVATE LIMITED141679.14
2000746881 ATOS INDIA PRIVATE LIMITED12902.95
2000980480 ATOS INDIA PRIVATE LIMITED246067.38
2000980469 ATOS INDIA PRIVATE LIMITED114980.69
2000980482 ATOS INDIA PRIVATE LIMITED79566.43
2000746830 ATOS INDIA PRIVATE LIMITED6315.12
2000980481 ATOS INDIA PRIVATE LIMITED306790.89
2000746838 ATOS INDIA PRIVATE LIMITED7268.95
2000986323 AUTOMATIC ELECTRIC LIMITED467160.28
2000994581 AVADH SUGAR & ENERGY LTD2553787
2000982829 AVADH SUGAR & ENERGY LTD2209014
2000982612 AVADH SUGAR & ENERGY LTD2211615
2000964166 AVADH SUGAR & ENERGY LTD1860799.5
2000972126 AVADH SUGAR & ENERGY LTD1886377.5
2000993275 AVADH SUGAR & ENERGY LTD1611881.25
2000994622 AVADH SUGAR & ENERGY LTD2553787
2000994623 AVADH SUGAR & ENERGY LTD2566620
2000994624 AVADH SUGAR & ENERGY LTD2566620
2000985918 AVADH SUGAR & ENERGY LTD2211615
2000994585 AVADH SUGAR & ENERGY LTD1851495.5
2000994587 AVADH SUGAR & ENERGY LTD2553787
2000693667 AVERY INDIA LIMITED23954
2000994640 Anant Infra160056
2000980337 B M ENTERPRISES1470462.61
2000992660 B.M. GLOBAL24450
2000994285 BABITA BASUMATARY1351600.43
2000994524 BABITA BASUMATARY698556.05
2000983853 BAJAJ HINDUSTAN SUGAR LIMITED2211615
2000983405 BAJAJ HINDUSTAN SUGAR LIMITED2276663
2000947245 BAJAJ HINDUSTAN SUGAR LIMITED2276663
2000948206 BAJAJ HINDUSTAN SUGAR LIMITED2566620
2000996355 BAJAJ HINDUSTAN SUGAR LIMITED2276663
2000983857 BAJAJ HINDUSTAN SUGAR LIMITED2211615
2000996383 BAJAJ HINDUSTAN SUGAR LIMITED2276663
2000996356 BAJAJ HINDUSTAN SUGAR LIMITED2276663
2000996385 BAJAJ HINDUSTAN SUGAR LIMITED2613282
2000996357 BAJAJ HINDUSTAN SUGAR LIMITED2613282
2000994036 BAJINDER MECHANICAL ENGG.WORKS24662
2000952377 BAJRANG TRADERS15741
2000943674 BALAJI AMINES LIMITED4927149
2000890440 BALAJI CONSTRUCTION2290.42
2000984429 BALAJI CONSTRUCTIONS213606.13
2000875507 BALAJI CONSTRUCTIONS204693.3
2000952875 BALAJI CYLINDERS1628098
2000986022 BALAJI ENTERPRISES36986.27
2000970780 BALRAMPUR CHINI MILLS LTD1869782.26
2000993308 BAMRAH ENGINEERS36067.22
2000993313 BAMRAH ENGINEERS190277.5
2000952877 BANKEYJI CONTAINERS PRIVATE LIMITED814049
2000956978 BCL INDUSTRIES LIMITED2219469
2000957081 BCL INDUSTRIES LIMITED2219469
2000995928 BEAUTY OF NATURE756882.23
2000995990 BEAUTY OF NATURE249857.35
2000991247 BECKMAN COULTER INDIA PRIVATE LIMIT2830952.16
2000995413 BEHAL SALES CORPORATION13860
2000933387 BEHERA ENGINEERING WORKS PRIVATE LI1788617.69
2000995374 BHADRIYA TRADING COMPANY10266
2000964910 BHARAT E & C SOLUTIONS24931.04
2000964911 BHARAT E & C SOLUTIONS24954.64
2000997399 BHARTI ENTERPRISES354000
2000976199 BIKANERVALA INTERNATIONAL1996.82
2000950087 BISWAS & SONS736655.22
2000959758 BISWAS ENGINEERING WORKS241451.3
2000858680 BM WORKS85804.88
2000992534 BODAL CHEMICALS LIMITED42514
2000972559 BODAL CHEMICALS LIMITED1222007
2000951074 BOMBAY FLUID SYSTEM COMPONENTS908516.22
2000952930 BRIDGE & ROOF COMPANY INDIA LTD7781972
2000944933 BRIDGE & ROOF COMPANY INDIA LTD7255522
2000974162 BUTTAR BIOFUELS PRIVATE LIMITED2508240
2000974198 BUTTAR BIOFUELS PRIVATE LIMITED2508240
2000974161 BUTTAR BIOFUELS PRIVATE LIMITED2508240
2000974163 BUTTAR BIOFUELS PRIVATE LIMITED2508240
2000974228 BUTTAR BIOFUELS PRIVATE LIMITED2508240
2000974194 BUTTAR BIOFUELS PRIVATE LIMITED2508240
2000845695 Bhagya Laxmi International95000
2000760713 Bharti Airtel Ltd.1737.33
2000969691 Bir Narayan Security Agency610742
2000961120 Blugent Hospitality Private Limited3990
2000970244 C&S ELECTRIC LIMITED49179.1

Team

Column1

User
Anju
Ankita
Binti
Garima
Jitesh
Lakshika
Naveen
Neel
Neetu
Raghav
Sanjay
Zubair
Vaishali
Ranjan Dash
Shubham
Shweta
1 REPLY 1
KuntalSingh
Helper V
Helper V

Can anyone help on this please 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors