Đã Đóng

Microsoft Excel Pivot Table Solution

I am trying to come up with a pivot table solution.

• In the attached spreadsheet ‘Data’ tab, Columns R and S list the ‘Agent’ and ‘Co-agent’ involved

• As shown in the ‘Pivot’ tab, I would like to achieve the following:

o A unique list of Agent and Co-agent from columns R & S

o A sum of the ‘Agency Score’ column AB relating to each unique Agent/Co-agent

Is the above possible using standard pivot tables?

Kỹ năng: Excel

Xem thêm: pivot table dashboard excel, pivot table vsto excel, pivot table project excel, excel table pivot, pivot excel table, create pivot excel net, convert table word excel, excel transform columns rows, excel convert columns rows

Về Bên Thuê:
( 0 nhận xét ) Indonesia

Mã Dự Án: #14687281

65 freelancer đang chào giá trung bình $89 cho công việc này

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Thêm

$155 USD trong 3 ngày
(173 Đánh Giá)
6.9
citijayamala

Expert in Excel pivot tables, Excel formulas, and all excel functions, macros, lookup concepts and pivot tables. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mark Thêm

$80 USD trong 3 ngày
(40 Đánh Giá)
5.0
$50 USD trong 1 ngày
(18 Đánh Giá)
4.2
awaisjahangir25

Reviewed your file. let me know i can do this one. I’ve 5 years of experience in accounts, finance, bookkeeping, reporting, financial analysis and various other projects. I’ve also worked a lot on Quick Books and Ora Thêm

$50 USD trong 1 ngày
(11 Đánh Giá)
4.1
sheak

Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hearing from you soon. Thanks!

$155 USD trong 3 ngày
(7 Đánh Giá)
4.0
humayoonsheikh4u

A proposal has not yet been provided

$30 USD trong 1 ngày
(8 Đánh Giá)
3.9
gumadevi89

A proposal has not yet been provided

$30 USD trong 2 ngày
(7 Đánh Giá)
3.0
ExpertzWorld

mecTo hire me directly, just copy and paste in your url "www.freelancer.com/hireme/expertzworld" ................................................................................... “Time. It’s what we writers fig Thêm

$30 USD trong 1 ngày
(3 Đánh Giá)
2.5
dayakmlt

A proposal has not yet been provided

$30 USD trong 3 ngày
(5 Đánh Giá)
2.0
$30 USD trong 3 ngày
(7 Đánh Giá)
2.2
anmolmathcs

-Experience in Excel and Pivot tables. -100% error free work can be expected. -Quick turn around time.

$40 USD trong 3 ngày
(3 Đánh Giá)
1.9
$50 USD trong 3 ngày
(1 Đánh Giá)
0.8
brunovilela4219

A proposal has not yet been provided

$35 USD trong 0 ngày
(1 Đánh Giá)
0.5
mrchambers

From your description I think a pivot table directly on the data should be feasible, but I'll need to see your Excel file to be sure. Please see attached "Excel Pivot Table Portfolio.pdf" (dropbox link below) for d Thêm

$80 USD trong 3 ngày
(0 Đánh Giá)
0.0
CesarHHC64

A proposal has not yet been provided

$200 USD trong 3 ngày
(0 Đánh Giá)
0.0
$40 USD trong 1 ngày
(0 Đánh Giá)
0.0
Luigi32

I've been working with spreadsheets everyday for years so i know what I'm talking about and pivot tables are one of my most used tools as they are very powerful

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0
Bwiker

I am very experienced in data analytics. I didn't see your spreadsheet but I believe you are very close to having what you need. I would create a unique field in your data tab that auto combines the Agent and Co Agen Thêm

$55 USD trong 1 ngày
(0 Đánh Giá)
0.0
humvale

Good evening, Sir. I have a substantial working experience using pivot tables, data extraction techniques, and data analysis for business purposes. I would be glad to work on your project. Your satisfaction is guarant Thêm

$55 USD trong 2 ngày
(0 Đánh Giá)
0.0
Amyrenea

A proposal has not yet been provided

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0