Display calculation based on data across rows

J

Jriker1

New Member
Joined
Feb 13, 2013
Messages
26
I have data for sales visits. We have the Target information and the Actual information. Sometimes there is no actual. That said, we have:

Report ID (not really relevant)
Days in Field
Number of Sales calls
Name of Sales Rep
Date
Type (Actual or Target)
Country

Below is sample data. I am trying to create a pivot report that I can filter by sales rep and country and see the difference between how much time they spent for a given day on sales calls (Actual) compared to what they thought they would (Target). Same for Sales call #'s. Would like to be able to show an overall row of information with:


Name of Sales Rep
Country of Sales Rep
Target Days in Field
Actual Days in Field
Difference between target and actual days in field
Target Sales Calls
Actual Sales Calls
Difference between target and actual sales calls

Then an overall value that shows overall difference between target and actual for days in field and sales calls based on current slicer settings.


So basicall where the date are matching, merge together.

Can someone help with this?


[TABLE="width: 575"]
<tbody>[TR]
[TD="width: 266, bgcolor: transparent"]Report Sales Call: Report Sales Calles Name
[/TD]
[TD="width: 64, bgcolor: transparent"]Days in Field[/TD]
[TD="width: 64, bgcolor: transparent"]Sales Call #[/TD]
[TD="width: 100, bgcolor: transparent"]Report Sales Call: Owner Name[/TD]
[TD="width: 68, bgcolor: transparent"]Date[/TD]
[TD="width: 64, bgcolor: transparent"]Type[/TD]
[TD="width: 140, bgcolor: transparent"]Country[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003348[/TD]
[TD="width: 64, bgcolor: transparent"]4[/TD]
[TD="width: 64, bgcolor: transparent"]22[/TD]
[TD="width: 100, bgcolor: transparent"]John Jones[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003287[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]334[/TD]
[TD="width: 100, bgcolor: transparent"]John Jones[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003589[/TD]
[TD="width: 64, bgcolor: transparent"]13[/TD]
[TD="width: 64, bgcolor: transparent"]169[/TD]
[TD="width: 100, bgcolor: transparent"]John Jones[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002218[/TD]
[TD="width: 64, bgcolor: transparent"]11.5[/TD]
[TD="width: 64, bgcolor: transparent"]165[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]1/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002239[/TD]
[TD="width: 64, bgcolor: transparent"]15[/TD]
[TD="width: 64, bgcolor: transparent"]210[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]1/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002318[/TD]
[TD="width: 64, bgcolor: transparent"]15[/TD]
[TD="width: 64, bgcolor: transparent"]208[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]2/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002349[/TD]
[TD="width: 64, bgcolor: transparent"]18[/TD]
[TD="width: 64, bgcolor: transparent"]252[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]2/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002419[/TD]
[TD="width: 64, bgcolor: transparent"]21[/TD]
[TD="width: 64, bgcolor: transparent"]260[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]3/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002460[/TD]
[TD="width: 64, bgcolor: transparent"]19[/TD]
[TD="width: 64, bgcolor: transparent"]266[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]3/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002598[/TD]
[TD="width: 64, bgcolor: transparent"]14[/TD]
[TD="width: 64, bgcolor: transparent"]205[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]4/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002542[/TD]
[TD="width: 64, bgcolor: transparent"]19[/TD]
[TD="width: 64, bgcolor: transparent"]266[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]4/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002652[/TD]
[TD="width: 64, bgcolor: transparent"]16[/TD]
[TD="width: 64, bgcolor: transparent"]218[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]5/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002605[/TD]
[TD="width: 64, bgcolor: transparent"]17[/TD]
[TD="width: 64, bgcolor: transparent"]238[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]5/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002730[/TD]
[TD="width: 64, bgcolor: transparent"]7[/TD]
[TD="width: 64, bgcolor: transparent"]61[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002744[/TD]
[TD="width: 64, bgcolor: transparent"]19[/TD]
[TD="width: 64, bgcolor: transparent"]266[/TD]
[TD="width: 100, bgcolor: transparent"]Abdel Man[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Egypt[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002578[/TD]
[TD="width: 64, bgcolor: transparent"]19[/TD]
[TD="width: 64, bgcolor: transparent"]263[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]4/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002632[/TD]
[TD="width: 64, bgcolor: transparent"]18.5[/TD]
[TD="width: 64, bgcolor: transparent"]328[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]5/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002712[/TD]
[TD="width: 64, bgcolor: transparent"]19.5[/TD]
[TD="width: 64, bgcolor: transparent"]352[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002779[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]329[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003324[/TD]
[TD="width: 64, bgcolor: transparent"]11[/TD]
[TD="width: 64, bgcolor: transparent"]212[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]8/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003325[/TD]
[TD="width: 64, bgcolor: transparent"]19[/TD]
[TD="width: 64, bgcolor: transparent"]336[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003297[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]334[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003414[/TD]
[TD="width: 64, bgcolor: transparent"]17.5[/TD]
[TD="width: 64, bgcolor: transparent"]312[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003574[/TD]
[TD="width: 64, bgcolor: transparent"]13[/TD]
[TD="width: 64, bgcolor: transparent"]169[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003626[/TD]
[TD="width: 64, bgcolor: transparent"]3[/TD]
[TD="width: 64, bgcolor: transparent"]47[/TD]
[TD="width: 100, bgcolor: transparent"]Pete Moss[/TD]
[TD="width: 68, bgcolor: transparent"]11/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002537[/TD]
[TD="width: 64, bgcolor: transparent"]18[/TD]
[TD="width: 64, bgcolor: transparent"]177[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]4/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002633[/TD]
[TD="width: 64, bgcolor: transparent"]21.5[/TD]
[TD="width: 64, bgcolor: transparent"]320[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]5/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002713[/TD]
[TD="width: 64, bgcolor: transparent"]21.5[/TD]
[TD="width: 64, bgcolor: transparent"]358[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002777[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]329[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002859[/TD]
[TD="width: 64, bgcolor: transparent"]21.5[/TD]
[TD="width: 64, bgcolor: transparent"]347[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]7/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002961[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]329[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]7/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003067[/TD]
[TD="width: 64, bgcolor: transparent"]14[/TD]
[TD="width: 64, bgcolor: transparent"]237[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]8/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003180[/TD]
[TD="width: 64, bgcolor: transparent"]20[/TD]
[TD="width: 64, bgcolor: transparent"]340[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003294[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]334[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003534[/TD]
[TD="width: 64, bgcolor: transparent"]18[/TD]
[TD="width: 64, bgcolor: transparent"]313[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003571[/TD]
[TD="width: 64, bgcolor: transparent"]13[/TD]
[TD="width: 64, bgcolor: transparent"]169[/TD]
[TD="width: 100, bgcolor: transparent"]Sue Rosman[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002584[/TD]
[TD="width: 64, bgcolor: transparent"]18[/TD]
[TD="width: 64, bgcolor: transparent"]113[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]4/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002634[/TD]
[TD="width: 64, bgcolor: transparent"]20[/TD]
[TD="width: 64, bgcolor: transparent"]317[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]5/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002771[/TD]
[TD="width: 64, bgcolor: transparent"]19[/TD]
[TD="width: 64, bgcolor: transparent"]333[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002775[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]329[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]6/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002870[/TD]
[TD="width: 64, bgcolor: transparent"]22[/TD]
[TD="width: 64, bgcolor: transparent"]350[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]7/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000002960[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]329[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]7/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003045[/TD]
[TD="width: 64, bgcolor: transparent"]8[/TD]
[TD="width: 64, bgcolor: transparent"]134[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]8/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003194[/TD]
[TD="width: 64, bgcolor: transparent"]21[/TD]
[TD="width: 64, bgcolor: transparent"]361[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003292[/TD]
[TD="width: 64, bgcolor: transparent"]18.3[/TD]
[TD="width: 64, bgcolor: transparent"]334[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003528[/TD]
[TD="width: 64, bgcolor: transparent"]17[/TD]
[TD="width: 64, bgcolor: transparent"]290[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003569[/TD]
[TD="width: 64, bgcolor: transparent"]13[/TD]
[TD="width: 64, bgcolor: transparent"]169[/TD]
[TD="width: 100, bgcolor: transparent"]Mark Roland[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Saudi Arabia[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003305[/TD]
[TD="width: 64, bgcolor: transparent"]16[/TD]
[TD="width: 64, bgcolor: transparent"]190[/TD]
[TD="width: 100, bgcolor: transparent"]Becky Olsan[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Jordan[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003269[/TD]
[TD="width: 64, bgcolor: transparent"]17[/TD]
[TD="width: 64, bgcolor: transparent"]238[/TD]
[TD="width: 100, bgcolor: transparent"]Becky Olsan[/TD]
[TD="width: 68, bgcolor: transparent"]9/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Jordan[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003463[/TD]
[TD="width: 64, bgcolor: transparent"]17[/TD]
[TD="width: 64, bgcolor: transparent"]212[/TD]
[TD="width: 100, bgcolor: transparent"]Becky Olsan[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Jordan[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003517[/TD]
[TD="width: 64, bgcolor: transparent"]16[/TD]
[TD="width: 64, bgcolor: transparent"]224[/TD]
[TD="width: 100, bgcolor: transparent"]Becky Olsan[/TD]
[TD="width: 68, bgcolor: transparent"]10/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"]Jordan[/TD]
[/TR]
[TR]
[TD="width: 266, bgcolor: transparent"]RSC0000003665[/TD]
[TD="width: 64, bgcolor: transparent"]3[/TD]
[TD="width: 64, bgcolor: transparent"]39[/TD]
[TD="width: 100, bgcolor: transparent"]Becky Olsan[/TD]
[TD="width: 68, bgcolor: transparent"]11/1/2013[/TD]
[TD="width: 64, bgcolor: transparent"]Actual[/TD]
[TD="bgcolor: transparent"]Jordan[/TD]
[/TR]
</tbody>[/TABLE]

Thanks.

JR
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
You must log in or register to reply here.

Similar threads

G
  • Question Question
Fuzzy Match code
Replies
1
Views
2K
gelu
G
P
  • Question Question
Problem with running 2 different macros
Replies
5
Views
933
pupsia
P

Forum statistics

Threads
1,223,965
Messages
6,175,660
Members
452,666
Latest member
AllexDee

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top