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 ...Calculated Field in form to table
Can you take a calculated field from a form and pull it in to a table??
...PIVOT tables and publishing thrm on a webpage
Is there a way to publish a pivot table in a html page but still kee
exactly the same funcitonality that you have on a Excel spread sheet
either by converting it to a java applet or something else . Any hel
would be much appreciate
Message posted from http://www.ExcelForum.com
...Pivot Table question #4
I have spreadsheets that take data via a pivot table from an OLAP cube that
is held on a terminal server.
The spreadsheets hold figures entered by me and figures obtain from the
I want to enable the automatic update on the pivot table but the pivot table
is sorted by a project number obtained from the OLAP cube. My problem is if
a new project is added to the OLAP cube then it is automatically selected
from the drop down list. I want to be able to turn this off so that it only
selects the project I have previously chosed. For example if I have selected
the filter nu...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?
...How to change background color of a window that has been created.
I need to change the background of a window that has been created, can
> I need to change the background of a window that has been created, can
> you help?
Answer depends upon the type of window. Typically you can do this in OnEraseBkgnd.
Certain controls respond to WM_CTLCOLOR and yet some other, like CButton,
need to be owner drawn to change the color.
If you have a generic CWnd, you can always specify the brush in the window
class; so no special painting is needed. This is good when you know that
the background will have one color all the time.
-...Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different
tables that are created dynamically by a query. The data for these will
but I would like to simply pull the data from these tables to create a report.
The tables have the following information:
1. Company Info (name, address)
2. Customer Info (address, name, etc)
3. Customer Order (products, price, other info)
4. Invoice Info (ID, GST #, etc)
I realize I could have created a table with relationships but the data above
dynamic as there are 4 different companies and based upon user inp...print folder in table style
My CU wants to print a list of files in a folder. He use Outlook 2002.
Click Other Shortcuts -> My computer -> choose a folder -> Click the print
icon on toolbar -> choose Table Style -> print preview
The header and footer can be printed properly. However the content is
blank. I mean: there is no file in the list.
I can print properly at my side. However at the CU side, there are 2000
users encounter the same problem. And there are four kinds of printer. All
have this problem.
Any suggestion? Thanks!
...creating a recurring reminder email message
I want to create a reminder message that gets emailed to a distribution list
on the same date every month. How can we do that?
...GP Extender Tables Question (GP9)
I have created an Extender window with 3 Fields (let’s just say price 1,
price 2, price 3). I can see where it got created in table EXT40100, field
User_Defined_Prompts_1 etc and I can also see where the data is stored in
EXT00103. What I don’t see is where the prompts from EXT40100 are in its own
rows so that you can link them to EXT00103 for reporting purposes. I know I
can hard code the flags to their proper values in Crystal or set up my own
custom table to do it but I would have thought that Extender will have a
table like that. Am I just not seeing it?
The prompts ...Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to
include them after refreshing. Is there any way of setting the pivot table
to include the entire database regardless of its continuously growing size?
Right now, as I add a new row of data I must delete my old Pivot table and
create a new one from scratch. Is this normal?
You can use a dynamic range that grows/contracts with your data.
Debra Dalgleish explains it all at:
> As I add new rows of data to my data base, my pivot table wil...Problem creating full text index
I seem to be unable to create a full text index of either my public or
private store. When I try to creat the index I get the error;
The directory name is invalid.
ID no: 8007010b
Exchange system Manager
This seems to be happening for both the public and private stores. The
directory does exist. I have looked over the permissions and tried to
compare to known working servers and I haven't moticed any obvious
differences. Any ideas?
Did you follow this article:
"Jonathan Huber" <JonathanHu...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?
...Install 3.0 Failed
I am in the process of installing 3.0 on a server. All of the inital checks
are fine. I proceed to install and it fails with an error "Action
Microsoft.Crm.Setup.Server.CreateSetupUserAction failed HRESULT 0x80040237"
I searched the Knowledge Base and found KB 941498. I did what it said but
got the following error for msxml2.dll - LoadLibrary("msxml2.dll") failed.
The specified module could not be found. How do I go about getting XML 2
(the parser I'm guessing) when it hasn't be supported in years?
Is there something else I can do?
I am installing 3.0...System Restore all off, still creating restore points on 2nd parti
Although we have System Restore turned off on all drives, restore points are
still being created on the secondary partitions.
The OS partiton is drive C, NTFS. The secondary partition is drive D, FAT32.
The restore points are being created when applications (i.e. DirectX,
WinDVD, etc.) are installed from the second partition (drive D). We must
install these from a secondary partition.
What are we missing? These restore points are filling up our drives.
Also, I thought System Restore wouldn't work on FAT32 drives?
Bill, I use two drives b...Create a new restore point
How does one create a new restore point in both Vista and Win7? When I go
to Accessories-->System Tools-->Restore all I get is how to restore from a
previous one. That's not what I want. I want to create a restore point.
On 3/9/2010 5:14 PM, OldManEd wrote:
> How does one create a new restore point in both Vista and Win7? When I
> go to Accessories-->System Tools-->Restore all I get is how to restore
> from a previous one. That's not what I want. I want to create a restore
Click "Computer" in start menu th...Turn on Automatic Formula Fill in Table
I turned off the 'automatically fill th column with this formula'
option in Excell 2007 but I can't see how to turn it on again. Can
anyone point me in teh right direction?
Excel Options > Proofing > AutoCorrect Options >
Autoformat As You Type > Fill formulas in tables to create
...Redefining a table range with a macro
I need help creating code to redefine a table within a macro. I used the
macro recorder to creata a table with the same name but to point to another
ActiveWorkbook.Names.Add Name:="Table1", RefersToR1C1:= _
How do I make this dynamic, so the starting point, #of rows and # of columns
are defined by variables?
Help is much appreciated.
On May 21, 4:57=A0pm, OMER <O...@discussions.microsoft.com> wrote:
> ...restore .ost file created in different exchange profile
Does anybody know how to restore email and other data from
an .ost file created by a different user in a different
domain name, please?
OST files are linked to the mailbox/profile for which they were created. If
you've got an orphaned one, you can't open it - you will need to google
OST2PST (an old utility that may still be floating around) and try to run it
against the file (make a backup copy first). Or see
www.exchangerecovery.com - I know it works, but it's $$$.
> Does anybody know how to restore email and other data from
> an .ost file created by a di...Checkbox column in a table
I am a newbie in MS Access. I want to write a query for altering a table
the new column added should be of type checkbox (which can be done by the
design by going to Lookup tab in the design form).
So when I open up the table that particular column should be like all filled
with checkboxes. (By Default it will be Textboxes).
And also how to give a default value to the checkbox ?
Please help me out... !
On Tue, 25 Sep 2007 12:52:20 -0700, Cormalado
>I am a newbie in MS Access. I want to w...Creating new P&ID master symbols
I would like to create a new master P&ID valve symbol and add it to the
Valves and Fittings stencil. I want to duplicate the tags and properties of
exisisting valves so that it functions like the other valves in the stencil
(auto-numbers, same data fields, etc.). Is there a way to copy all the
information (not just the shape properties) from one valve and apply it to
the new one?
Use the Shape Conversion command from the Process Engineering menu to do
this. Here are the steps:
1) Drag an existing valve onto the page so that there is at least one valve
in the document.
2) If your ...Money 2005
I have used Money 2003 for 2 years now. I did not use ANY of the online
features nor did I have a .NET Passport. I just purchased Money 2005. I
took my existing .mny file and converted it for use in Money 2005. I enabled
my checking account (from US Bank) to use online services. NOT ONLY did 2005
create a brand new duplicate account with my recent activity in it (see my
other posting), BUT it also duplicated most of my existing budget categories
For example, I had an existing category called "Day Care". Now I have two
of them: "Day Care" and "Day Car...Adding two fields to a table
I current have the following code which works perfectly now:
[CODE]CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me.
List12 & """)", dbFailOnError[/CODE]
I would however like to add another field's information named (Lnd_Desc) as
well in the same row of table (Input). What should my syntax look like for
Message posted via AccessMonster.com
INSERT INTO [Input] ([Loc_Desc], [Other Column]) VALUES
(""" & Me.List12 & ...How do I create a 4-d chart?
I am trying to create a chart with 4 dimensions. In effect, I need a 3-D
column chart where the vertical bars are "stacked" colmns. How can I do this?
Have you heard about Tufte's "small multiples" or Cleveland's "trellis"
displays? These approaches create a series of small plots instead of trying
to put everything into a single overly complex chart. I would stay away form
3D charts in Excel.
Trellis is a trademarked by Insightful software. I use the term "panel
charts" to reflect trellis and small multiple charts in Excel. I have...stop creating email link when @ sign is present
I want to stop the autoformatting when the @ sign is used in a field. How can
I stop excel from automatically creating an email link when the @ sign is in
This feature can be turned OFF under Tools, AutoCorrect, the second tab,
AutoFormat as You Type, unclick the first option Internet and Network Paths
> I want to stop the autoformatting when the @ sign is used in a field. How can
> I stop excel from automatically creating an email link when the @ sign is in
> a cell?
You don't say whic...