Totals For An Inside Row Field In a Pivot Table

Hello,

Is it possible to get totals for an inside row field in a pivot table?
I have a table in layout as follows:

     Row Fields - Section, Year
     Column Fields - Rev, Exp, FTE
OR:


...........................................Rev...........Exp.............FTE
Sect............Year
3425...
.....................2000................$$$.........$$$.........##
.......................2001.................$$$.........$$$.........##
........................2002................$$$.........$$$.........##
3428...
.....................2000................$$$.........$$$.........##
.......................2001.................$$$.........$$$.........##
........................2002................$$$.........$$$.........##
.....ETC.

What I would like is to a Total by Year for all sections.

Thanks.

0
jbesr1230 (21)
1/25/2006 6:02:43 PM
excel 39879 articles. 2 followers. Follow

1 Replies
719 Views

Similar Articles

[PageSpeed] 9

You could move the Year field to the column area, then the column totals 
would be per Year, and the row totals would be per Section.

jbesr1230@hotmail.com wrote:
> Hello,
> 
> Is it possible to get totals for an inside row field in a pivot table?
> I have a table in layout as follows:
> 
>      Row Fields - Section, Year
>      Column Fields - Rev, Exp, FTE
> OR:
> 
> 
> ..........................................Rev...........Exp.............FTE
> Sect............Year
> 3425...
> ....................2000................$$$.........$$$.........##
> ......................2001.................$$$.........$$$.........##
> .......................2002................$$$.........$$$.........##
> 3428...
> ....................2000................$$$.........$$$.........##
> ......................2001.................$$$.........$$$.........##
> .......................2002................$$$.........$$$.........##
> ....ETC.
> 
> What I would like is to a Total by Year for all sections.
> 
> Thanks.
> 


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
1/25/2006 6:46:01 PM
Reply:

Similar Artilces:

Moving rows #2
In Word2K, I can shift table rows up or down with Alt+Shift+Up/Down Arrow Is there a similar keyboard shortcut for Excel2K? -- David The best I can suggest is.......... Highlight the row you want to move.........Right click > Cut > Right click to highlight the row below where you want the cut row inserted > InsertCutCells Vaya con Dios, Chuck, CABGx3 "David" <dturner4_1999@yahoo.com> wrote in message news:u862$UceFHA.4040@TK2MSFTNGP14.phx.gbl... > In Word2K, I can shift table rows up or down with Alt+Shift+Up/Down Arrow > Is there a similar keyboard short...

Counting Consecutive cells in a row with a value greater than zero
I have 7 cells in a row (D39:J39). Default value of these cells will be 0.00. I want a cell to display the count of cells whose value is greater than zero. How do I do this? I was looking at DCount - but from the documentation in help that I looked at, the values tested need to be in a column. - is this correct. Any example will be appreciated - Thanks - Sean Hi Sean try =COUNTIF(d39:j39,">0") hth Keith "Keith74" <keith.willis@sbjbc.co.uk> wrote in message news:1180614455.498158.304370@o5g2000hsb.googlegroups.com... > Hi Sean > > try &...

How row heights are determined in Excel
Is it possible to change the unit of measure of row heights settings lets say to centimeters or inches? How? Hi Anne, The short answer is no. Row height is measured in points or pixels. 72 points or 96 pixels per inch. Don't ask about columns!!! Biff >-----Original Message----- >Is it possible to change the unit of measure of row >heights settings lets say to centimeters or inches? How? >. > See http://www.erlandsendata.no/english/index.php?d=envbawssetrowcolumnmm for a small macro that does it. This said, you can zoom both a spreadsheet window and a printout, an...

An XML question
I would like to produce the following output based on my XML file: My Album (2005) Elapsed Time (hh:mm:ss): 00:07:00 Song 1: title1 Length (hh:mm:ss): 00:02:30 Song 2: title2 Length (hh:mm:ss): 00:02:15 Song 3: title3 Length (hh:mm:ss): 00:02:15 ===== <album> <general> <title>My Album</title> <year>2005</year> </general> <content> <song> <songTitle>title1</songTitle> <songLengthInSeconds>150</songLengthInSeconds> </song> <song> <...

Totals on Sales Inquiry native windows
We would like to have the totals on the Sales Inquiries: Transaction by Customer Transaction by Document Sales Documents Sales Items Today we can retrieve this information in separated inquiries and reports, be we would like to heve a easier way to see this totals... The same suggest can be applied to Smartlist. If possible, you can create a tool to sum a field after you make a filter I created a screen where you can see all sales, separated by day of week, and week of year, and totals YTD,MTD and WTD, but I am not able to have the same information grouped by item number, for example.....

Custom icons in Enterprise Custom Fields
Is it possible to load up my own .gifs or .jpgs so that the server is able to make use of them in the custom icons for formulas? I'm assuming that all of the icons reside in a specific directory on the server, which I would then add to. Hi Brian, Project Server or Project does not accomodate to use your own pictures. Sorry to say. -- Marc Soester [MVP] http://www.i-pmo.com.au "Brian Lukanic" wrote: > Is it possible to load up my own .gifs or .jpgs so that the server is able to > make use of them in the custom icons for formulas? I'm assumi...

Limiting a drop down list to a value in another field
Hello, I have an Access database which lists certain software. There are two fields; the software company, i.e. Microsoft, and then the name of the software itself,i.e. Access. I want the name of the software to be limited by the company name, so the second drop down would not list, say, Adobe Acrobat. Is there a way to do this? Many thanks in advance. Joanne wrote: >I have an Access database which lists certain software. There are two >fields; the software company, i.e. Microsoft, and then the name of the >software itself,i.e. Access. I want the name of the softwa...

Attach Rows with Row Data
I am trying to sort by Data/Time in a Column, but if I sort by Date/Time, Just that changes, the other columns don't change with it. How can I either LOCK or ATTACH the Rpw data together so when I sort, Everything changes, not just the Date/Time? Thanks Mike Miller Hi just select the entire data range (all columns) prior to sorting your data -- Regards Frank Kabel Frankfurt, Germany "Admiral_Kirk_1" <Admiral_Kirk_1@discussions.microsoft.com> schrieb im Newsbeitrag news:BAFA6FEE-04C3-4AFB-9FA6-CFF7A41224C9@microsoft.com... > I am trying to sort by Data/Time in a ...

changing row height
Is it possible to change the row height within the same sheet of some rows without it affecting the other rows? -- A fledgling at 64 hi yes it is. are you having trouble of any kind?? to set a row....on the menu bar>format>row>row height set the height to what you want. you may have to experiment. once set to the desired height and you need to set other rows to the same height, select the other row and hit the f4 key. this is the repeat action key. the set the height of the select row to the same height as the last row. if you need to have different heights then you ...

is there a Dlookup to get entire record or multiple fields ??
I am using Dlookup to get a records key value then i am using 4 seperate Dlookups with that key value to do some math in VBA and its killing me. here are my lookups InstallID = DLookup("[installID]", "T_installhistory", "TRKID = " & Me![TRKIDCombo] & " AND RemovalDate = #" & RmvDate & "#") InstallTSN = Nz(DLookup("[installTSN]", "T_installhistory", "installID = " & InstallID), "UNK") InstallTSO = Nz(DLookup("[InstallTSO]", "T_installhistory", "ins...

total cost on report
I have areport with a cost field that I would like to total that collum at the end of the report. How do I do this ? do I need to create another field (total) please help thanks, jettro Jettron wrote: >I have areport with a cost field that I would like to total that collum at >the end of the report. How do I do this ? do I need to create another field >(total) The usual way is to use a text box with an expression like: =Sum([cost field]) -- Marsh MVP [MS Access] I'm in design view of the report, where do I insert this expression? I clicked on page footer to insert thi...

Sending a email from inside Excel
What I have done is created a time sheet for a month, and it also gives me the hours that are worked in a week. Do what I would like to do is when the week goes over 40 hours send a email, a pop-up or some kind of message that this person went over thier time. Can this be done? Thank you Kelly Hi Kelly Start here http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Kelly Thompson" <KellyThompson@discussions.microsoft.com> wrote in message news:28ACBCD9-AD87-4699-A933-9A4197423C8A@microsoft.com... > What I have done is cr...

Setting ID# to 1 & Total on bottom of query result
Hi, I have 2 separate questions. First how do I set the ID# to 1 for the first record. I copied my whole database including queries and forms which were 2009 records and changed the titles to 2010. I did a "compact and repair" to the 2010 database. But when I start to enter records for 2010 the ID# is 2550. How can I reset the ID# back to start at 1? On many of my queries I have the results be for example 28 Caucation, 43 African American, 65 Hispanic, 4 Asian, 2 Native American. I need these numbers separate like they are but I would like a total line at the bottom...

macro
I have several columns in an income sheet. One column has a sum at the bottom. I want to be able to run a simple macro that will copy the last row of formatted cells, just above the sum total, and insert it as a new row just above the sum total so another line of data can be input. But I want the sum total to sum also the newly inserted row. Presently I can't figure out how to do it. Example A B C 1 24 Oct Dollars In $100 2 25 Oct Dollars out $25 3 Total ...

League Tables for sports events
I am trying to find a way to "data-sort" in real time. I have a league table set up for my football team which lists team name, games played, games won, games drawn, games lost, goals for, goals against, goal difference, and points awarded total. The table auto-populates with the scores I enter into a fixtures sheet. All I would like to do is to formulate a way to get the whole table to "data-sort" in real time, in the following order ... Sort by points total (descending), then goal difference (descending) Please could someone help me? Thanks Mike E Take a look at...

Copying rows from one Excel spreadsheet to another
At my office, we use Excel 2000 (9.0.3821 SR-1). I have a daily spreadsheet that I maintain and add comments to one of the cells. At the end of the week, I maintain a weekly spreadsheet in which I copy the rows in which I have comments to the weekly spreadsheet. Sometimes, it allows me to also copy the comments, and at other times, it does not, and then I have to re-add them. Can you come up with a reason and a solution? What do you mean by "allows me"? If you do a regular copy as in ctrl + C it will copy everything, if you only want to copy comments, copy and when pasting do e...

tables and numbering
I have created a six column table in Publisher. The items in each column (or cell) are numbered items using " bullets/numbers". The first three columns are listing items by number 1,2,3, etc. However in the last three columns they are acting like they are linked: first column lists 1,2,3, second column lists 4, third column lists 5. Second and third columns should begin with listing "1". The formatting under the bullets/numbering option seems to be formatted correctly. Any ideas? Suggestions? Do a return, then another return, the next column will revert to one...

Finding Cells that Total a Value
Hello Friends, I need some assistance in solving a problem. I have a spreadsheet with over five hundred lines of transactions. The sum of these transactions are creating a balance on the account. Is there any formula/macro that will help me find the transactions creating the balance? The sum of the account should be zero. To clarify, if we owe client money, there would be a transaction setting up that postive balance then a payment on the account taking it back to zero. There could be multiple transactions and then one net payment. Or we could be due to receive. So at the end of the day, th...

invisible graphics and tables
I have upgraded my computer to a P4 3Ghz and FX5600 256Mb Graphics Card and New Matrox Hard Drive.. Since formatting and re-installation of PUBLISHER i can not see my Tables or Word art and a few graphics only the Fonts are Visible. The documents print fine everything is there but i can not see them on the monitor. I made up a new File saved it then re executed it and the same thing happens. Have all updates in, changed refresh rates, latest Nvidia driver, Reinstalled Publisher and updates. PLEASE HELP ME BEFORE IT GOES OUT THE WINDOW!!!!!! Why is it that the first thing people wan...

jump to row
Hi all, I posted this problem yesterday and was very grateful for the reply below, however I have carried out the instructions but it does not seem to work or I do not understand it correctly, any other help would be great. p.s I am inexperienced at macros so please explain in simple terms.Thank you again in advance your help on this site is much appreciated. I have an inventory with 500 rows all with a number i.d Is there a command by where I can input the i.d (say 450) I wish to view into a cell (say B1) at the top of the page and the row will be shown even if it is off the visible p...

Access 2007 Change field size setting
I am new to access 2007 and it is considerably deifferent from 2002. I have a field (column) which should be a catalog number. I want to enter numbers such as 001-001, 001-002, etc and an error message keeps appearing that " I have entereted text in a numeric field or a number that is larger that the field size setting permits" I have searche dthe property sheet and can not find a field that will allow me to change the field size, also when I try and change the format from "general number" to a text it oly gives me numerical options to choose from. Please help if ...

Total Items
Hi - Is there a way to get a total number of items that are about to be tendered, on the POS screen ? Thanks. You can customize the status.htm file. Not sure exactly what the variable is that you want, but I know it cn be done. "NJS" <NJS@discussions.microsoft.com> wrote in message news:538F3CC7-F23D-43C7-8A5A-4319B8688E5B@microsoft.com... > Hi - > Is there a way to get a total number of items that are about to be > tendered, > on the POS screen ? > Thanks. Jason, Send me your email I have already customized this and will forward you. "Jason&qu...

Sharing lead & opportunity tables
Hi, Does anyone know which tables store info regarding lead/opportunity that are being shared to other users? Thanks Carrie Hi Carrie, The lead and opportunity information is stored in the leadbase and opportunitybase tables. Information regarding the sharing with other users, is stored in the principalobjectaccess table. The settings in this table are reflected in the SecurityDescriptor field with every lead and opportunity. Hope this helps, Ronald Lemmen Avanade Netherlands "Carrie" wrote: > Hi, > > Does anyone know which tables store info regarding lead/oppor...

what is the perl table ??? and how i can use this
...

Dropdown for Inside Address in letter headers
I am working to create a company letter template. I want each office to be able to choose their office from a drop down box in the header and have it update with the full address, phone, fax, etc. for the appropriate office. I have seen this done before so I know it's possible, but don't seem to be able to make it work. Any suggestions or guidance would be greatly appreciated. You might try an AutoTextList field. See http://word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://wor...