Pivot table formulas
I am trying to create a calculated field in a pivot table but cannot get the
expression to work correctly.
I have a field called Class Description and I need to perform a COUNT
function on it. I have entered =COUNT('''Class Description''') as the
formula but Excel always returns 1.
Does anyone have any ideas how I can resolve this please?
if its a text field then excel will automatically "count" it when you drag
it into the data area - or am i completely misunderstanding what you're
"Alan Bentley" <...how to know rowindex after filtering
Via VBA i filtered a sheet. Basically i should have as result only 1 row.
How can i know what is the rowindex (figure in the grey column margin
e.g : 873, or 34245,...) ?
thanks a lot,
Dim myCell As Range
Set myCell = Nothing
On Error Resume Next
Set myCell = .Resize(.Rows.Count - 1, 1).Offset(1, 0) _
On Error GoTo 0
If myCell Is Nothing Then
I want some set of questions on Word-2007 to check competency level of the
user. Please help.
Ananta, please refer to my other 2 postings: just check out the WORD part.
If my comments have helped please hit Yes.
"Ananta Gupta" wrote:
> Hello Everyone,
> I want some set of questions on Word-2007 to check competency level of the
> user. Please help.
> Ananta Gupta
> Ananta, please refer to my other 2 postings: just check out the WOR...I want more!
I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?
I usually select the last row in the range and copy it down a few rows.
If you're using xl2003, you may want to look at Data|List.
And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
> I need to extend a form that aleady has some 100 lines. For instance, one
> column has the da...PurchasePrice field in table IV00102
Does anyone know why this field exists?
In our configuration, there are no values in it (all 0's).
I want to store a value (for informational purposes only) - specifically,
the item's standard cost per site.
I would greatly appreciate some opinions on this.
This is from the SDK on the CD:
Purchase price to use in determining which vendor to use when generating
purchase orders to replenish this item/site (only when POP Pricing Selection
is “Use Specified Price”).
> Does anyone know why this field exists?
> In our configur...Need help with table set-up and Thanks!
I’m about to finish my first database and am in the planning stages to create
another. I want to express my gratitude to all that helped me with this. I
learned more with the help of this group in three months than in three years
of reading books and taking classes. I have the utmost respect for all of
you kind people. I just hope that I’ll be able to find you all when they
close down this site.
I need some guidance about my table set-up. I’m going to have a data table
that will be updated each month for employee, project and hours worked. I
want to have a master tab...Remote Users for GP 8.0
We have a remote site with 5 users that are connected to us via a T1 point to
point at 1.5mbps. We would like to have these w/s connect to run great
plains. Is a vpn possible? SHould we use a terminal server? Any advantages
in using citrix?
I would usually recommend Terminal Server 2003 for what you're describing.
VPN only (without TS or Cirtix) is not supported by MS, nor advisable, even
over a point to point T1 you're not going to like the performance. Citrix
doesn't really offer too many advantages over TS for 5 users, but is also a
viable alter...I don't want a page of the same label, I want one of each...
I can't find where to tell Pubisher that I want one of each label and not a
page of each label.
I'm using Publisher 2003 (Office 2003)
I see a post that says to enter "<<Next Record>>" but Publisher doesn't see
this as a field, just as text.
This can't be that hard, but I can't figure it out...
Any help would be appreciated.
I see that it prints correctly, but the print preview displayes it wrong....
I think I have it figured out...
"Kelvin" <email@example.com> wrote in message
news:OSpLwThUIHA.5508@TK2MSFTNGP04.phx....importing tables in proper format from word 2007 into access 2007
The word 2007(.docx) is saved as a plain text(.txt) file first. Then,
I add a delimiter(#) to each row
manually. The tables in the document look like below
Row 1 data#
Row 2 data#
Row 3 data#
Row 4 data#
Row 1 data#
Row 2 data#
Row 3 data#
Row 1 data#
Row 2 data#
Row 3 data#
and so on
Then, go into Access 2007, External Data, Text File to import the text
file data into Access choosing # as the delimiter
The table which is created in Access 2007 is as follows
Row 1 data of Table 1
...Text want wrap in text box
I can't get the text to wrap in a text box, word wrap is set to true, I put
some text boxes on a sheet today and the text will not wrap, I did this
yesterday and it worked fine, I can copy the ones from yesterday and paste
them on a new sheet and they work, any ideas? I have rebooted but this did
not help. Using Excel 2000 (9.0.6926 SP3) Thanks Paul B
If you're referring to a Control Toolbat text box make sure that the
MultiLine property is True.
"Paul B" <firstname.lastname@example.org> wrote in message
news:%23ovLUkuLEHA.2456@TK2MSFTNGP12.phx.gbl......Look-up Table for "packaged pricing"
1) Have looked in archives - either don't know how to describe this well, or
can't find similiar challenge
2) Have looked in my Excel 2003 Help files - either don't know how to
describe well, or can't find similiar challenge
3) Look forward to hearing how y'all would do this...<grin>
CHALLENGE: Build a "look-up" table to calculate/look-up price based on
position of [0s or 1s] or [Blank] in a particular column/position:
- My client's Web-hosting company sends us orders (in excel...Want to Add more Sub description Field
How I can add more sub description field like 1,2,3,4,5
You have only limit up to 3 fields in RMS 1,2,3 sub-description also you can
use the extended description and there is main description for the item. so
Altogether you have upto 5 description limit and I think that is enough. Let
me know if this won't fulfill your requirements else use the Item Notes for
Rate if like
"Saleem Suri" wrote:
> How I can add more sub description field like 1,2,3,4,5
> Saleem Suri
...Dynamics GP routing link several BOM's at once
When using routing links allow selection of several items at once to link to
a routing step instead of one at a time.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=487897...GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had
upgraded from previous version to remove dups in smartlist tables) and when I
log into GP as sa, it hangs and CPU sits at 100%.
When I was able to log in previously to SP#2, I constantly received errors
about the CN_Collector_MAIN table with invalid column names etc. I've
deleted the table, then re-ran the create tables, but it keeps coming back
with this error. I've even gone into file > maintenance > sql and deleted
and recreated the table, but then get "number of results doesn't match ...I want to add a sound event when the cursor bumps left margin
I want to know (via an event sound) that my cursor movement has bumped the
left edge of the spreadsheet. I am entering thousand of rows of data, and it
would help if there was a event sound when I returned the cursor to the left
edge. I have this feature in 123, and find it helpfull.
Put this in the sheet module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static ColOld As Integer
If Target.Column = 1 And ColOld > 1 Then Beep
ColOld = Target.Column
mvpearl omitthisword at verizon period net
I need help with editing "Comments" field which is under blue arrow on invoice line.
After posting invoice this field (as others) becomes grey - non editable.
Any ideas how to change its value ???
...Updating tables in GP10
We need to update address tables in GP10.
All of the Fields on the tables are set to null = N.
Some of the address fields in our input source has nulls. What can we do to
be able to get our data into the tables
What is your source? CSV? TXT? a SQL table? an XML file?
What tool will you be using to integrate the data? eConnect? Integration
Manager? a SQL update statement?
Usually, if your address has nulls in the source, you should be able to
replace with a blank character ("", or '' depending on the source) not a
Mariano Gomez, MI...Excel wants to create a page break in every cell!
After saving revisions in an Excel worksheet, I get a popup message that
states "Margins do not fit page size". After clicking "ok" (because this is
my only choice) a page break is automatically created in ever cell. At
times(depending on the sizeof the work sheet) it can be over 100 pages with a
page size 14% or smaller.
Why does this happen, and how can I avoid it?
I saw this suggestion in a different forum.
Try closing excel.
Clean up your windows temp folder
Windows start button|Run
and hit enter
Clean all those files that you ca...custom number formating in a merge table?
I am trying to merge fields into a table from an excel file and I would like
to formating to appear the same as the excel formating. Some of the
formatting in excel is custom ie. if the phone number is 1234567891 I want it
to show as (123) 456-7891. How do I do this?
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originall...WANTED
WTB: I BUY SOFTWARE - CHECK AROUND - YOU PROBABLY HAVE SOME OF THE
BELOW TO SELL TO ME.
SEE A LIST OF SOME OF THE SOFTWARE THAT I AM BUYING!
I AM BUYING ALL OF THE BELOW. THE MORE QUANTITY THE BETTER!
I am looking to buy large quantities of Windows 7 Professional Upgrade
Dell DVDs with unactivated COAs included in a SEALED package
I am looking to buy quantities of SYMANTEC NORTON ANTI VIRUS, NORTON
INTERNET SECURITY AND 360 OEM AND RETAIL BOXES
I will buy 2010, 2009, 2008, 2007 and 2006.
If you have good quantities setting around and no longer need send me
Hi---I am setting up a form with various check boxes. I want to set up a
range of check boxes so if any of these boxes are checked, then one
corresponding check box if also checked. On the flip side, if none in the
range of boxes are checked, then the one corresponding box is also not
I hope this can be done with a formula or conditional formatting, instead of
a macro....if it takes a macro, whoever resonds to this question, please
explain in easy terms---I don't have a lot o fmacro experience.
A boolean checkbox reflects the TRUE / FALSE value of the cell it ...Rename Multiple Tables at once
I have an Access 2007 database that has a lot of linked tables and I
want to 'batch' rename them. For example, they all start with "dbo_"
and I want to rename all of them to "PM_". How can I make that
happen? I've been searching and cannot find a solution. Any help
that anyone can provide is greatly appreciated.
Dim dbCurr As DAO.Database
Dim tdfCurr As DAO.TableDef
Set dbCurr = CurrentDb()
For Each tdfCurr In dbCurr.TableDefs
If Left(tdfCurr.Name, 4) = "dbo_" Then
tdfCurr.Name = "PM_" & Mid(tdfCurr.Name, 5)...I want to know something about Visual Studio 2005
I want to know something about Visual Studio 2005
the size of it , and the System Requirements, who knows , please tell me.
Thanks a lot.
Ajay Kalra [MVP - VC++]
"fcvcnet" <email@example.com> wrote in message
> I want to know something about Visual Studio 2005
> the size of it , and the System Requirements, who knows , please tell me.
> Thanks a lot.
Thank you so much!
But I can not find the Visual Studi...When repeating city want zipcode to populate
Making a data base of mailing addresses. Is there a formula to use to get a
zipcode to populate in a cell when a city and state is entered in two other
See help on VLOOKUP function.
Or go here for excellent help and an example workbook.
Gord Dibben MS Excel MVP
On Wed, 21 Feb 2007 08:05:32 -0800, jrw - esq. <jrw -
>Making a data base of mailing addresses. Is there a formula to use to get a
>zipcode to populate in a cell when a city and state is entered in two other
>...multiple pivot table generation
I m using office 2003. I have a sheet containin gmy base data,
Now i want to generate multiple pivots from the base sheet, based on some
filter condition. i.e. pivot 1 should only consider rows having column Age >
Pivot b should consider rows having column city = 'Dallas' ..... and so on.
Please let me know how to do this with single base sheet.
You can do this with a single Pivot Table
Drag Age and City to the Page Area of the table, then use the dropdown
on each to select the criteria you want.
"Vikram" <aa@aa> w...