Pvt Table Question #2

Hi,
I'm in excel 2007.  I have a couple of really big sheets and would
like to make a pvt table.  My question is - is it possible to make a
pvt table using two sheets?  If so, how do you do this?  Thanks!
0
lj1 (84)
2/20/2009 7:49:58 PM
excel 39879 articles. 2 followers. Follow

1 Replies
657 Views

Similar Articles

[PageSpeed] 36

Alt/DP, then choose Multiple consolidation ranges -- the UI was removed from 
the ribbon.

"lj" <lj@spu.edu> wrote in message 
news:a137474c-7ea2-4c35-a9ab-43af7056c140@x38g2000yqj.googlegroups.com...
> Hi,
> I'm in excel 2007.  I have a couple of really big sheets and would
> like to make a pvt table.  My question is - is it possible to make a
> pvt table using two sheets?  If so, how do you do this?  Thanks! 


0
rumlas (268)
2/20/2009 8:47:23 PM
Reply:

Similar Artilces:

average formula help #2
We have a range of cells A1:A10 which contain values as follows:- 1 2 4 5 0 0 6 8 9 10 We need Cell A11 to display an average of A1 to A10 but ignoring the 0 values. Is this possible with a formula? Thanks in advance Kevin Kevin, try this =AVERAGE(IF(A1:A10 <>0,A1:A10 )) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "kevin carter&quo...

Pvt Table Question
I am creating several pvt tables that will be updated often with new data. I want to know if there is any function within a pvt table that I can use to set up my pvt table so that only the top 10 data points are automatically displayed. So for example, if i have pvt table set up to show brand name and then accounts for each brand name and I sorted on accounts descending and only wanted the pvt table to show the top 10 brands that had the highest total accounts. Is this possible? Thanks. Hi, To show the top 10 values for a field - double-click the field heading, click 'Advanced' ...

new company #2
I want to add a new company to the existing one. Existing is 001-01-**** I want to add a new one 002-01-**** This is for a company that will report seperatly first one or 2 years, but than will be integrated in the main company. Is this is good way of doing or should I create a new company which I have to enter into the main company in 2 or 3 years anyway. Can I transfer all the old info from one company into an existing one? Thanks Henk ...

pivot tables #33
Thank for helping me whith this. I nned to create a calculated fiel where ia can divide a value in a row by the total of the value column. sonething like this. +A35/A100 where A100 is the total of the colum. So the result will be a porcentage. This have to be a calculated field inside the pivor table. Thank for your help. -- MG Instead of a calculated field, you can add data fields to the pivot table. In the pivot table wizard, double-click the data field button Click the Options button For 'Show data as', select % of column. mariagloria wrote: > Thank for helping me w...

Tax Setting Question for Propane Distribution Company
Hi, I am working for a propane distribution company. The propane industry has a special regulations for GST and PST, that is PST is based on the quantity sold, and the PST is included together with the sales subtotal to calculate GST. For example, for a 100 litres propane sales @0.6/litre, PST will be 100*0.027(flat charge for PST), GST will be (100*0.6+100*0.027)*GST rate. How should I set up the tax schedule? Customer A might be GST and PST applicable for propane, while Cust B might be only charged with GST for propane. But both of them will be charged with GST and PST when th...

Narrowing a table into an area
My table looks like this: A 100 A 110 B 300 B 310 B 320 C 200 D 210 D 220 How would I identify the rows with B in the first column to be used in the INDEX formula's first parameter? =INDEX( [rows with B], 2, 2 ) giving me the value 310 Thanks! This will give you the answer you want...you are specifically telling the formula to find the second value (represented by +1) in column B that has a value of "B" in sorted column A: =INDEX(B:B,MATCH("B",A:A,FALSE)+1) "Hall" <hall@garp.org> wrote in message news:%23%23FrHMdWHHA.3980@...

Field question
I looked for a standard field which might be called "company activity" meaning what business is the company involved. Strange that this is missing. Before I make a custom field perhaps someone would confirm? Beemer What program are you talking about? If Outlook, what version? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Beemer asked: | I looked for ...

C/C++/VC++/MFC/SDK,Coding contest at StreamNet(India)Pvt Ltd #2
This coding test is primarily on C/C++/VC++/MFC/SDK related technologies and is designed to pick the very best of developers to work on our cutting edge technologies. The winner of the first prize takes home a cool Rs.1 lac! There are other consolation prizes to be won as well with a special token of appreciation for the 1st and 2nd runners up! Top 10 candidates will get the offer from Streamnet India Pvt. Ltd. To participate you need to apply to our following Email id with your resume codingcontest@streamnet.com The candidate should possess a B.E./BTech./MCA degree from reputed university ...

pivot table
When I add data to my excel spreadsheet and update my pivot table with the new cell range, the new data is automaticlly selected in the drop down feilds in the pivot table. Is their any way to have the pivot table update but leave my orginal selections in place. For example here is a very simple senario: My orginal data has 10 cost centers, I only select five of them when making my pivot table report. I update my data with an additional 7 cost centers. When I update the pivot table the orginal 5 cost centers are still selected but the new 7 cost centers are also selected. I want t...

Sorting Options for Pvt Tables
I am creating several pvt tables that will be updated often with new data. I want to know if there is any function within a pvt table that I can use to set up my pvt table so that only the top 10 data points are automatically displayed. So for example, if i have pvt table set up to show brand name and then accounts for each brand name and I sorted on accounts descending and only wanted the pvt table to show the top 10 brands that had the highest total accounts. Is this possible? Thanks. Double-click on the Brands field button In the Pivot Table Field dialog box, click the Advanced button...

An open operation on table POP_PO_TEMP has an incorrect record len
Has anyone seen this message? One of our users opens the Purchase Order Entry screen and before she can enter anything, a dialog box opens with the above message. Sometimes when we clear the message, she's able to continue...other times, not. It seems to clear up after a few tries or after logging out and back on. Today was the first time this happened...other users are opening the window with no problems. -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 i'm not on a computer with dynamics/dex loaded...

One question about ADO
I want to use ado to access database in my vc++ application. First of all I put the line [#import "c:\program files\common files\system\ado\msado21.tlb" rename_name("MSADO") using namespace MSADO;] into the StdAfx.h file of my project and build the project, the IDE output two compiling errors that are as followed: [e:\my develop\gotest\debug\msado21.tlh(1112) : error C2629: unexpected 'short (' e:\my develop\gotest\debug\msado21.tlh(1112) : error C2238: unexpected token(s) preceding ';'] the code in line 1112 of msado21.tlh is [VARIANT_BOOL EOF;] I'm p...

How do I show the Table details I entered in Table properties
I like to view my comments regarding the tables I create in MS Access. But when I enter the comments in the Table Properties under Table details I cannot view the details in my list view. Is there a way to view them? Which version of Access are you using? Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ __________________________________________ "DBuser" wrote: > I like to view my comments regarding the tables I create in MS Access. But > when I enter the comments in the Table Properties under Table details I > cannot view th...

Excel 2007 Beta Charting Problem/Question
I was trying to get an answer out of the Excel tech yesterday but she could not help. In prior versions of Excel you have the ability to drag datapoints on a line chart around. It would either just make a change to that cell ref or if it was a cell that was dependant it would start the goal seek utility and ask for the cell that needed changed to make the change to the cell that your changing. I have the Beta version now and this seems to be either turned off or does not exist any longer. So are there settings that I'm missing or has this been taken out of the new version? Thanks f...

HR Accrual schedule setup #2
I would like suggestions on setting up the Accrual schedule setup: at 3 months, employee gets 20 hours from 3 months to 60 months, they accrue 3.54 hours per payroll from 61 months to 120 months they accrua 1.54 more (in addition to the 3.54) Any suggestion on how to set this up in the accrual schedule setup? Also, is there a process or a step in Dynamics to accrue this vacation? or does it automatically do this when I am running payroll? Also, with the accrual schedule setup, does it use the start date from employee maintenance? Doug -- Doug ...

filter form on value from linked table
Is it possible to filter a form (based on table A) on a value in a table B where the tables are linked? Table A ID lastname firstname companyid ... Table B companyid companyname ... I would like to filter the form records (Table A) by using as input the company name (or part of it) from a textbox. Thank you -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200704/1 Sorry for this but I forgot I would like to use like frm.Filter = as I already use it to filter the form based on values from another txtbox on the lastname -- Message poste...

Ex2003 Fails to mount Pvt OR Pub store automatically, but manual w
Greetings all! I'm running MS SBS2003, with ISA Server, Symantec AntiV Corp Edition 9.0 + Symantec AntiV for MS Exchange 4.5 The problem: When the server is rebooted, 90% of the time, the 'Public Folder Store' fails to mount, and the 'Mailbox Store' mounts fine. I can then go into Exchange Sys Manager, and manually mount the store, and this works no problem. Sometimes it is the 'Mailbox store' which doesn't mount, but can also be later mounted manually. One of the stores will ALWAYS fail to mount, while the other will mount fine. The errors in the ...

Pivot Table #35
I am trying my hand at making a pivot table. When I go to Data/Pivot Table and Pivot Chart Report, it is grayed out. Is it is because it is "read only" and shared. Are there any other ways to make reports in excel 2000. Thanks You can't create a pivot table in a shared workbook. You could create the pivot table in a different workbook, and use the data from the shared workbook as the source. syssupspe wrote: > I am trying my hand at making a pivot table. When I go to Data/Pivot Table > and Pivot Chart Report, it is grayed out. Is it is because it is "read only&q...

2 Questions #5
1. I remember using this utility several years ago to access edb file on a very low leve in order to delete a corrupted message. For the life of mine i can't remember what it's called. 2. I have whole bunch of log files which are not being commited. How can i force them to be commited to database if i don't want to wait. I'm using exchange 2000 std on windows 2000 server. thank you very much Are you thinking of mdbvu32 or eseutil ? Be very careful with any utilities that access the information store at a low level as you can easily damage the database. How do you kno...

An OLE registration error occured #2
Hi, When I start Outlook 2000, I get the message "An OLE registration error occured. The program is not correctly installed. Run setup again for the program". When I press OK it closes. I tried to repair did not work. I uninstalled it then installed again still not working. Note that I am experiencing some kind of adware/hijacking with internet explorer. Word, Excell and Access work properly. How can I fix the registration error. Thanks for your help. jmassry. ...

table is not displayed in word 2003 while copy the table form web
hi friends , there is a table in web page. i am trying to copy it and past to word 2003.but the datas only displayed without table. please any one help me to solve this problem If you copy the data and look in the Paste Special dialog box (Edit | Paste Special), which options are available there? -- Stefan Blom Microsoft Word MVP "Akbar" <Akbar@discussions.microsoft.com> wrote in message news:CC17B9EE-0299-470F-BF7D-F73E70958D6C@microsoft.com... > hi friends , > > there is a table in web page. i am trying to copy it and past to word ...

Table of contents
I have created a large spreadsheet with numerous worksheets and would like to be able to insert a table of contents at the front of the report. Each heading in the table of contents would be the worksheet name. Is there any way of doing this? I know I can put a table of contents page in the report and fill in the page numbers by manually doing a print preview and then filling in each page number manually. Any help would be greatly appreciated. Hi have a look at http://www.mvps.org/dmcritchie/excel/buildtoc.htm -- Regards Frank Kabel Frankfurt, Germany Dave wrote: > I have created a l...

Question on Printing Subtotals
Probably answered dozens of times, and I did a Google search with no success. I have subtotals calculated in three fields, Puchase Price, Paid, and Balance. I hide the details to Copy - Paste only the calculated subtotals to another workbook, but all the details are pasted as well. Is there a way to suppress Pasting the details. I could obviousy accomplish this with a Pivot Table, but management prefers the display provided by Subtotals. Many thanks. use a macro for specialcells(xlvisible) or use f5 goto special>visible cells only -- Don Guillett SalesAid Software donaldb@281.com &...

Distribution List permissions #2
Exchange 2003 in native mode. How do I protect a DL so that only certain IT personnel can add/remove members to this DL? There seems to be someone that has permissions to modify some of the DLs in our environment and I need to prevent that from happening. Thanks. Distribution Groups are AD objects and have permissions/ACLs just like any other AD object. Modify the permissions to restrict who has rights to change it. -- Bharat Suneja MVP - Exchange www.zenprise.com NEW blog location: www.exchangepedia.com/blog ---------------------------------------------- "Edward" <Edwa...

Pivot Table with MS Access as DataSource
Hello all. Thanks for the help in advance. I am trying to use a UNC to pull data from a MS Access database as a external datasource for a pivot table in MS Excel 2003. I can actively pull the data, since I have a network drive mapped to the location, but others who have the drive mapped to another letter are unable to open the document and refresh. I am trying to figure out the best way to create this pivot table utilizing the shared network UNC. Please help! Regards, Me Hello, I would use a SQL query to pull the data out of the Access db. Then everyone can push...