In Progress

Excel PivotTable Help

I have a dynamically created Excel Workbook that includes a PivotTable. Pivot Table needs to be modified to sum some dollar fields by month. So in the source data we have installed amount, installed date, booked amount and booked date.

I need it to look like this in PivotTable format:

Customer Estimated Revenue July Aug Sept

Booked Install Booked Install Booked Install

Microsoft 400,000 100,000 300,000

Oracle 100,000 25,000 75,000

IBM 300,000 100,000 200,000

The source data will look like this:

Company Name Estimate Revenue Booked Revenue Book Date Install Revenue Install Date

Microsoft 400,000 100,000 July 14, 2011 300,000 Sept 29, 2011

Oracle 100,000 25,000 Aug 22, 2011 75,000 Aug, 29, 2011

IBM 300,000 100,000 July 10, 2011 200,000 Aug 22, 2011

The source data is being dynamically pulled from Microsoft Dynamics CRM. Upon winning, I will provide the actual spreadsheet.

Skills: Excel

See more: oracle company name, ibm customer, crm microsoft dynamics, spreadsheet microsoft excel, pivot table excel, Microsoft Dynamics, Microsoft Dynamics CRM, help name, format excel, excel table, excel PIVOT, excel pivot table, dynamics crm\, customer help, CRM Dynamics, help crm, excel modified, microsoft dynamics crm install, excel 200, Microsoft Dynamics CRM 2011, actual estimate excel, excel data table, look table excel, help source, need help book

About the Employer:
( 4 reviews ) Cumming, United States

Project ID: #1140560

Awarded to:

microk

Let's start.

$30 USD in 1 day
(28 Reviews)
4.4

12 freelancers are bidding on average $32 for this job

vserv

Pls see your messages. Thanks

$30 USD in 1 day
(60 Reviews)
5.8
usmanvardag

Please check my PM for details

$30 USD in 1 day
(5 Reviews)
4.3
kulhanekd

I can do this for you. Thanks Donna

$30 USD in 1 day
(10 Reviews)
4.4
momo2619

Dear Sir, Please look to PM and the attached file Thanks

$30 USD in 0 days
(6 Reviews)
2.9
ausdavid

Give me a chance.

$30 USD in 2 days
(1 Review)
0.9
limonzmnbd

Ready to [url removed, login to view],check your PMB,thanks.

$50 USD in 3 days
(0 Reviews)
0.0
srsurajjain

Hi Please check PMB

$30 USD in 0 days
(0 Reviews)
1.1
fplalane

im ready to start

$32 USD in 1 day
(0 Reviews)
0.0
Algotrade

Details in the PM.

$30 USD in 0 days
(0 Reviews)
0.0
Aminbithi

Hi BenVollmer, I'm very much interested to the project. I will give you with in 2 hours. See the PM please.

$30 USD in 0 days
(0 Reviews)
0.0
lynfreelancer

ready to start

$30 USD in 2 days
(0 Reviews)
0.0