Rearrange data columns in Pivot Table
In a pivot table, how do you rearrange the column order in the data
Right now I show columns named A, B, C, and Grand Total.
I want to be able to rearrange them as follows (for example):
Grand Total, B, A, C.
I am using Excel 2000.
i'm not sure if you can move the "grand total" column, but the others can be
easily re-arranged by just typing the names in the order you want (ensure
that you don't make any typing errors though), what i mean is,
click on the A heading and type B
once you press enter B will now come first and A will be moved
continue as req...How do I make the results of a Query into field names on a table?
I have a query with just one row of data - how do I make that row of data as
the field names of an existing table? If not existing table can it be done to
a new table? Can it be done at all?
In query design view, choose Append on the Query menu (or in Access 2007,
Append on the Design ribbon.)
Access adds a row to the design grid where you can map the fields.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"M Chahal" <MChahal@discus...Implemeting Portals in Great Plains?
What are the requierments to implement Portals for Great Plains for other
branchs to be able to access it online through the internet? Does Microsoft
provide a While Papers for Portals Deployements Guide ?
There are a few white papers concerning Business Portal, a Sharepoint-based
portal. You may want to log into CustomerSource and review them.
"MS GPS" <email@example.com> wrote in message
> Hi All,
> What are the requierments to implement Portals for Great Plains for other
> br...Suppress Zeros in a Pivot Table
Can I suppress zeros in a Pivot Table? Many of the results are zero, how can
I hide the rows without using a macro.
You could add a column of formulas in a hidden part of the pivot table
worksheet, then use it to filter the pivot table.
For example, if your pivot table is in cells A3:J100, and has two row
fields, enter the following formula in cell R2:
Copy the formula down to the last row to which the pivot table will
In cell R1, enter a heading, e.g. Filter
Select cell R1, and choose D...what does "data source reference is not valid' in Pivot table
Can someone tell me how to resolve 'data source reference is not valid' error
while creating a pivot table
I Googled your question and found 21,000,000 + answers.
Could luck !
'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=126977
...Pivot Tables #12
Hello. Is there a way for pivot tables to count a field only if it contains a
string of characters?
I want to count results that contain "a", and results that contain "b" etc.
...MS Publisher: How to change master pages w/o opening the master?
I have numerous different master pages that work in all of my documents.
I would like to change master pages in a document without having to open the
master page. Is there any kind of shortcut keys. Cuttently I have to hit
"ctrl m" then close the master to get the "apply master page" window open to
Doesn't the Master Page task pane open? Right-click the toolbar, customize, view,
drag the Master Page to the toolbar.
Mary Sauer MSFT MVP
"JimO" <JimO@d...calculated field from a form to table
Can you take a calculated field from a form and pull it in to a table??
You can but you should not. Instead, calculate the value each time
you need it. Stored values are almost guaranteed to get out of synch
sooner or later.
"Darren" <Darren@discussions.microsoft.com> wrote in message
> Can you take a calculated field from a form and pull it in to a
Ok, makes sense. If i wanted to do it to get a snapshot and save that in the
table, how do you do this?
"Larry Daugherty" w...Master Post - Financial Series
Hello, we have Post TO GL so after posting in the sub series, there
are batches in the Financial series that need to be posted. But how
do I view the transactions that make up those batches? When I mark /
unmark a line and click the Batch ID hyperlink then the Transaction
button, it doesn't display any transactions. What is the best way to
review the transactions that make up a batch in Master Post -
The same Batch Entry window opens from Master Posting as from any
other area in GP. When you click on the Transactions button, you have
...Pivot Tables drag & drop
Sometimes when I attempt to create my Pivot Tables in 2007 it will not
let me drag and drop my data in the new sheet. It won't show the
small icon for columns or rows. I have to drag it to the box on the
bottom right(row labels, column labels...etc). Don't know how to do
the VALUES. But my problem is the drag and drop and icon displaying.
I only see this problem in some 2007 spreadsheets when I create the
new Pivot Table. Don't know if I'm doing something wrong.
Is this a know problem that can easily be resolved?
How can I fix this problem?
After creating t...Update Master Project
I have two Projects located in the same folder. They are named Master and
KTR Updates. Is it possible to use vba to update the master Project with
updates from the KTR Updates project? Each week I receive a new KTR updates
project from KTR production. I've queried this group for this issue but was
not able to locate one. Updates could possibly include updates in progress(%
compl), start, finish, actual start, actual finish. Updates may also have
completed tasks removed from the KTR updates Project as well as new tasks
added. I'm primarily interested in acq...MS CRM Install & Config Master Certification
I am planning to get the "CRM Installation & Config Master Certification"....
I already took the three "base" Certification Exams for CRM...(plus I
already have Exam 70-228 on SQL Server)
Micrsoft (US Site) states that you need 4 exams (and this would mean I am
already certifided right now), but the Italian sub-site says you need 6 exams
to get this certification...
I alreday wrote to MBS group in order to get a clarification, but no reply
Is any of you certified on CRM? if yes, which certification and how many
exams did you take???
Hi, I believe there is a way to do this but it's been quite a while since
I've had to do anything like it.
Is there a way to create one template datasheet as a 'master' sheet and then
have several copies of the master. Whatever changes occur in the master
will flow into the copies?
It really depends on *exactly* what your meaning of "copies" is.
If you're talking about opening a 'copy' of the template, adding data and/or
calculating, then *saving* under a different name in a pertinent (read other
then template folder), AFAIK, the an...Reading Outlook 2002 Mail in Plain Text
I recently moved over to Outlook from Outlook Express. The version of =
Outlook I 'own' is Outlook XP/2002 which I have running on Windows XP.
In Outlook Express I could choose to read all my email in plain text. If =
I wanted, I could choose to display the HTML in an HTML-formatted email =
by pressing ALT+SHIFT+H.
I've read the MS knowledgebase article that explains how to read all my =
email in plain text in Outlook 2002. But is there a similar keyboard =
combination or some other way that I can choose to see the HTML?
No, you can't quickly convert to HTM...Can a field from Non-Great Plains "product" be added to Report Wri
Hi, I am working on modifying the AR Historical Aged Trial Balance report in
There is a one field I need on my report from a non-Great Plains "product",
Wennsoft Job Cost to be specific.
Wennsoft's Job Cost contains a field called "Job Name" and I want to put
that on my GP AR aging trial balance.
The problem is when I go into Report Writer and select product "Great
Plains", I cannot create table relationships with the product "Wennsoft" to
establish the link.
Does anyone know how I can pull this Wennsoft field onto my AR Aging ...data tables #2
I have a modest spreadsheet i'm using for a linear
programming problem which computes five results from two
inputs. I am trying to automate the process so i don't
have to manually change the inputs and then transfer the
outputs by hand.
THE data table function would do the trick but i can't
figure out what to use for the function. the functional
dependences are not easily describable with a formula
like x,y=f(a,b,c,d,e) that can be entered into one cell.
Rather they are buried in the formulas that make up the
spreadsheet. I tried using "scenarios" but the manu...Tables Update Interrupted #2
What does this mean? The accountant was in the process of posting this batch
and the above status of the batch comes up. I went into batch recovery, now
the status is marked.
Somehow that particular batch got marked. Asking the user to log out and
logging in back sometimes take away the marked status. If it doesn't, Go to
SQL, Run the following query against DYNAMICS Database
UPDATE SY00800 SET MKDTOPST = 0 WHERE BATCHID = "XXX"
--REPLACE THE BATCH ID WITH YOUR BATCH
> What does this mean? The accountant was in...Retrieve tables from web with variable URL
http://www.bibf.be/ipc/tamenu.asp has a field "postcode", asking for
a 4-digit entry and leading to the links of all members of that postal
code when all other inputs are omitted.
The visible URL in the URL bar , however , remains unchanged.
I have a list in Excel with several postal codes e.g. 2200 2500
2222 3000 for which I want to retrieve the members tot list them up
on a worksheet. I know enough VBA to do that if I only knew the key
to build that postal code into the URL. Is there a way to do that?
Thank you very much for any help.
...Pivot Table unable to Include Hidden Items In Subtotals
I have set up a pivot table that lists only the Top 10 values in a column,
but also want the subtotal for the entire column, including the hidden items.
Excel Help tells me that I can click the "Include Hidden Items in Totals"
button, but the button is not available. I followed the help instructions to
first select "Subtotal Hidden Page Items" then to unselect it and didn't get
my result in either case. Any ideas on why the button is not available?
AFAIK, that button is only available if your using an OLAP cube as the
For other sources, you can ...how to print a master sheet together with another sheet
i need to print a master sheet with a result sheet it is in the same workbook
but on a different sheet but i need to print them on one sheet
...Anyone using Open Air with Great Plains
My company is implementing Open Air with Great Plains. If anyone is using
Open Air, I would like to discuss how you are exchanging data with Great
Plains. Please post.
My email is firstname.lastname@example.org
Hi Scott, the VAR I used to work for are using Open Air and import invoicing
from it through IM. You might want to contact them to see if they are willing
to help you or at least give you a few hints. See their web site to contact
> My company is implementing Open ...email invoices in batche via Forms Printer with Great Plains 8
We use Forms Printer with Great Plains 8.0, sp2 for our Sales documents and
have been very pleased with it.
We have just begun emailing invoices to our customers, so far just a small
test pool. If we manually create a separate batch for just these customers,
emailing works great.
But we don't normally manually create batches. We typically create, via
integration manager, 2 invoices batches each day of about 100 to 300
invoices, with the email customers' invoices interleaved with the standard
print ones. If, by batch, I choose a Forms Printer sales document and choose
'Pr...formula in a pivot table?
is that true that excel-pivot is only able to sum (meanvalue is no
selectable) from a formula made table. usually you put by drag and dro
the data field
into your table. but you also can put by hand a formula which is quit
sometimes. after lunching the data-field in your pivot you can say
show me the minimum or the meanvalue.
It looks like that is not possible when you create a data-field using
then excel is just able to sum that ****...
do you have any other idea??
------------------------------------------------------------...Sum a table of columns & rows
I have a spreadsheet of 154 Rows (all unique project numbers in numerical
order) and 9 columns of account numbers (some are similiar and some are user
entered, therefore there could be 'blanks' with no data in them).
I am trying to create a table that will only give me the project number if
there are dollars in one or more of the columns. This would be used for data
entry (and that is why I would like to have the columns summed up - to remove
Any ideas? I have given a brief example below:
F, G, &am...master
What is meant by master and master shorcut in Microsoft Visio?
A Master is a shape definition. It stores all the information about a
shape: it's geometry, text, behaviors, formatting, custom properties, etc.
It also stores the icon you see in the Shapes window. When you open a
drawing and see shapes in the Shapes window, you are looking at Masters.
You can drag a Master onto the drawing to create a Shape instance.
The difference between a Master and a Shape is not that important to most
users, and we often refer to both items as shapes. If you begin to create
your own shapes, M...