Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that
have subtotals associated with them (automatically generated via the
pivot table). I need to to take the subtotals for 2009 and 2010 and
calculate the % difference.
Here's a screenshot of what I'm talking about:
Is this even possible or am I going to have to do this manually?
Hi I have'nt seen the screenshot as am at work , go to Pivot
>This is what I need to do: I have rows of ...Daylight Savings Time Changes
Does anyone know if the patch for Exchnage 2003 identified in KB926666 has
to also be applied to every server that is running the Exchange Tools (System
Thanks in advance
On Wed, 31 Jan 2007 10:24:03 -0800, Kerry
>Does anyone know if the patch for Exchnage 2003 identified in KB926666 has
>to also be applied to every server that is running the Exchange Tools (System
>Thanks in advance
Im all for consistency. If the patch isnt needed, it shouldnt install,
so I would at ...Calculated Field in form to table
Can you take a calculated field from a form and pull it in to a table??
...how do Ii remove the grey page numbers in a work sheet
how do Ii remove the grey page numbers in a work sheet
Try going to the View menu and unchecking Page Break Preview
On Wed, 2 Feb 2005 11:01:08 -0800, "parker1230"
>how do Ii remove the grey page numbers in a work sheet
You may be in page break preview mode.
Go to "View" and select "normal"
"parker1230" <email@example.com> wrote in message
> how do Ii remove the grey page numbers in a work she...No calculation on new machine
I run XP Home with Office 2002
I have just installed my programs to a new machine.
Excel is behaving differently on the new machine:
Observed so far:
i) I cannot select a cell by moving with the arrow keys.
ii) I can insert a calculation, SUM for instance, into a cell and I
get a 0.00 result.
iii) Format > Cells provides three options, Border, pattern and
protection. The old machine additionally gave me number, alignment and
What have I miised?
Check your status bar that you do not have SCRL on the
right side to indicate Scroll Lock (there i...Windows mail times out sending wmv file in windows mail
Cannot send a wmv file 5.10MB, recieves just fine but times out when sending.
The size is probably the issue. An attachment adds to the size about 35%
due to encoding, so your 5.10MB file is now roughly 7MB. You can try the
following, but it will only help if your server allows a message of that
In Tools | Accounts | Mail | Properties | Advanced, set the time-out
slider to the max.
Turn off e-mail scanning in your anti-virus program. It is a redundant
layer of protection that eats up CPUs, slows down sending and receiving,
and causes a multitude of problems such as ...logging date & time of data entry for individual cell
I'd like to log the time & date that content was entered into a (formerly
When any data is manually entered into cell A1, the then-current time & date
goes into cell B1 (and henceforth doesn't change). When data is entered into
A2, the then-current time & date goes into cell B2. Once data has been
entered into a cell, it will not be edited again.
Can anyone suggest the best way of doing this?
Put the following macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("A:A")
If Intersec...Division for TOTAL
Historical price for TOTAL (FR:FP) remains stopped at split date (may 18th
2006 - 4 for 1) and has not bit divided. Yield calculation on Money are
The American ADRs for TOT are ok; are prices for other securities
"Michel Gervais" <Michel_Gervais@Compuserve.com> wrote in message
> Historical price for TOTAL (FR:FP) remains stopped at split date (may 18th
> 2006 - 4 for 1) and has not bit divided. Yield calculation on Money are
> consequently ...table and form not calculated in synch
Help says to open a piviot table but I am having trouble making my columns
add up to total for each indivudual ID. The totals are being calculated only
in th e form view which does not up date the original table and does not
transfer to a report. How can I get a feild to calculate specific feilds so
that I can run these reports?
...Subtract several rows from a total
This is a multi-part message in MIME format.
I have a total in cell C32. I want to subtract numbers in cells C 34-40 =
and have the answer in cell C41. I know that =3DC32-C34 will give me an =
answer but I want several rows to be subtracted. What would my formula =
I have used the insert function feature before but I don't see diff or =
anything that looks like a subtraction function in there. =20
------=_NextPa...Adding Values From Different Tabs
Is there a way to add values from different tabs on the same
For example A2 from tab 1 and A2 from tab 2
Flipkid2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17984
View this thread: http://www.excelforum.com/showthread.php?threadid=398184
Assuming the name on Tab 1 is Sheet1 and Tab 2 is Sheet2, use thi
note the name of the sheet is followed by "!" to indicate it is a shee
------------...Total is sum of bold values
Suppose I have a the following columns in a Excel
A B C D
4 (b) 6 4 (b) 5
6 6 (b) 6 (b) 6
3 (b) 6 (b) 4 4
6 4 (b) 3 1 (b)
7 16 10 1
The totals add only the values that are bold..
(b denotes bold text)
How can I make this (Total/Bold) functionality to work in
"Saj" <firstname.lastname@example.org> wrote in message
news:09ea01...Use Outlook Client when domain user name different with email acco
I have a question about using Outlook Client.
If the domain user login name is different with email account which belong
to a same person, is it possible to install / login with the Outlook client?
e.g domain user : degdom\apple
email account: email@example.com
One of my client is facing in this situation. I just want to have some
preparation before install Outlook Client for him.
Thanks for any help!
It shouldn't be a problem if the AD user is the same used to start
Outlook and connect to CRM.
You may want to check the email adress in CRM if the ema...Business Portal - Executive
Does any one have any idea to fix Total Expenses Query - web part under
Executive tab of the business portal to display selected company result
instead of only Fabricam's data always irrespective of the company selection.
You can select the company.
Go to Site actions - Edit the page, then Edit the query, then on the Modify
Query window go to the Options tab and select the company there.
"Naseer Farooqi" wrote:
> Does any one have any idea to fix Total Expenses Query - web part under
> Executive tab of the business ...Help with Calculation #2
Hi, I have the following XLS with 3 sheets: Credits, Inventory &
Credits sheet (Stock sold) columns:
'Product Code', 'Product' (Text field) & 'Quantity'
'Product' (Text field), 'Company', 'Supplier', 'Product Code',
'Quantity', 'Cost Price' & 'Retail Price'.
Debits Sheet (Stock bought) columns:
'Product Code', 'Product' (Text field), 'Quantity' & 'Total cost'.
New stock entered as 'Product Code', 'Product', 'Quantity...Calculate from another sheet
If i in a sheet have
a1=1 , b1 =2 , c1 = 3 , d1 = 4, e1 = 5 and so on
a2 = 100, B2 = 100, c2 = 100 , e2 =100 ans o on
Then in another sheet
i write maybe 4
then i want a cell there have a sum from 1 to 4
In this case from a2 to e2
if I write maybe 2
The a sum from a2 to b2
Can i do this?
If 4 is A2 to E2, and 2 is A2 to B2, presumably 3 is A2 to about half way
between C2 and D2?
It sounds as if you want the OFFSET function; details in Excel help.
"alvin Kuiper" <alvinKuiper@discussions.microsoft.com> wrote in message
new...How do I create a spread sheet for tracking batting statistics?
Trying to keep a running log of batting stats for the season. Can anyone help?
> Trying to keep a running log of batting stats for the season. Can anyone help?
...Calculate Dates with If Then Else Statements
I need to calculate total years’ full time experience (i.e. 2.5 years, 3.25
years, etc.) in an Access 2003 database form. This is what I am trying to
do: If the Full-Time End Date is Blank, use Today's Date, ELSE if the
Full-Time End Date has a Date, use that Date.
Separately, these two formulas work:
My problem is writing a statement to calculate using the END DATE if one is
entered, or NOW, if there is no end date. I have tried many combinations,
but can’t ge...Running macros for different cells at the same time
Is it possible to run different macros on different cells at the sam
time? If so how do I go about setting it up?
Message posted from http://www.ExcelForum.com
not really sure what you're trying to do. Could you give an example?
> Hi all,
> Is it possible to run different macros on different cells at the same
> time? If so how do I go about setting it up?
> Message posted from http://www.ExcelForum.com/
Yes it is possible to run different m...Outlook locks up all the time
This is a shot in the dark. Ever since getting my new
Thinkpad with Windows XP, Outlook has never seemed to work
properly. I've run diagnostics on my machine and nothing
comes up as a problem. I've installed a spyware program
because after talking to IBM tech support, they suggested
I try that. I also talked to another support tech, who
suggested I reinstall Windows completely. I'm not a real
technical person. Won't a re-install wipe out my files?
Most of the time that I use Outlook for my email, it slows
down and eventually locks up. When I restart my computer,...Running Totals
I have several fields that I want to sum and display a text box with a
running total. I do not want to store the total I just want to display the
Thank you for any assistance you can offer.
If you mean fields in the form's record source, then create a hidden text box
for each field (if it is not already bound to a control on the form). Then
in the text box where you want to show the sum use the Control Source
=Nz(textbox1,0) + Nz(textbox2,0) + NzUtextbox3,0)
Dave Hargis, Microsoft Access MVP
> I have several fields...MC++ & C# generate different XML
I've been trying a long time now to generate some XML using MC++ and
XmlSerializer. I have a piece of C# code that produces exactly what I want,
but I simply can't get the MC++ code to write the same thing. Below I have
included two minimal compilable samples that illustrate my problem.
The C# code produces this XML:
<?xml version="1.0" encoding="utf-8"?>
<Units name="unit1" />
<Units name="un...conditional formatting: separating rows with differing values
Need help with conditional fomatting.
What I need:
I got a worksheet with 950 rows and 5 columns. The first row contain
the headers. Columns A, B, D and E contains unique values. But the
column C contains text values which repeats sequentially for 6-7 rows
and changes thereafter. Now I want to put up a line (using border)
through the whole row dividing this transition row.
Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so
on till 2 consequtive values differ. Now divide the 2 rows using the
border formatting option in conditional formatting dialog box.
So..."A Formula or sheet..."
Windows Vista Ultimate - SP1 RC1
Office 2007 Professional
When I try to copy a worksheet I get the following:
"A formula or sheet you want to move or copy contains the name '_XXXX',
which already exists on the destination worksheet. Do you want to use this
version of the name?"
This messages appears many time before the sheet is finally copied. I have
been clicking the yes button and the task is completed. Is there a
work-around, or add in, that allows me to go in and delete all these names
so I can just copy the sheet w/o all the extra effort. It seems to me I ran
i...Crosstab Query For Fiscal Year Totals
I want to write a crosstab query for FY totals that will show each month
regardless of wether there is data or not. Any help on this is greatly
The trick is column headings. Open the query in Design View. Right click up
where the tables go and select Properties. In there is column headings. Put
in the expected column names in order. Something like:
"Jan","Feb","Mar" and so on.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.