Đã Đó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, convert attached spreadsheet html table, pivot table project excel, pivot table macro excel 2010, excel table pivot, create pivot table dynamically excel, excel 2007 table pivot table, pivot excel table, vba excel lock columns refreshing sheet, create pivot excel net, convert table word excel, excel transform columns rows, net sql server table write excel pivot, excel convert columns rows

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

Mã Dự Án: #14687281

64 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
(184 Đánh Giá)
7.0
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
(21 Đánh Giá)
4.5
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
(8 Đánh Giá)
4.5
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
(16 Đánh Giá)
4.3
humayoonsheikh4u

A proposal has not yet been provided

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

A proposal has not yet been provided

$30 USD trong 2 ngày
(7 Đánh Giá)
3.8
$30 USD trong 3 ngày
(9 Đánh Giá)
3.3
dayakmlt

A proposal has not yet been provided

$30 USD trong 3 ngày
(12 Đánh Giá)
3.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
(4 Đánh Giá)
2.9
ExpertzWorld

mecTo hire me directly, just copy and paste in your url "[url removed, login to view]" ................................................................................... “Time. It’s what we writers fig Thêm

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

A proposal has not yet been provided

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

Yes, this and more complex analysis can be done using Pivot tables. This will also allow you to update and add new information to the source table and you can update the pivot table to reflect the new data.

$66 USD trong 3 ngày
(0 Đánh Giá)
0.0
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 [url removed, login to view]" (dropbox link below) for d Thêm

$80 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
$55 USD trong 2 ngày
(0 Đánh Giá)
0.0