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:

http://home.comcast.net/~wilsoch/PercentDiff.jpg

Is this even possible or am I going to have to do this manually?
0
wilsoch
5/18/2010 9:31:51 PM
excel 39879 articles. 2 followers. Follow

1 Replies
1894 Views

Similar Articles

[PageSpeed] 31

Hi I have'nt seen the screenshot as am at work , go to Pivot
Table>Formulas>Calculated Field

wilsoch@comcast.net wrote:
>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:
>
>http://home.comcast.net/~wilsoch/PercentDiff.jpg
>
>Is this even possible or am I going to have to do this manually?

-- 
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-new/201005/1

0
sidm
5/19/2010 4:19:43 PM
Reply:

Similar Artilces:

Difference in the listing of the New module addition in 2002 version
Hi, I have Excel 2002 at home and also at work. At home when I add a new module (using Insert module) Then it gets listed under "VBAProject (Book1)" and it is in the same tree node as "Sheet1 (Sheet1)", "Sheet2 (Sheet2)" , "Sheet3 (Sheet3)" "This Workbook". There is no separate "Microsoft Excel objects" folder. While at Work when I insert a new Module it gets added under a folder called Module which is basically part of the tree node "VBAProject (Book1)". Also at work I have a separate "Microsoft Excel objects"...

Pivot Table Data Fields Won't Total
Hello, I'm trying to create a chart to display 3 categories (ATM,VRU,WWW). I get the Data from a SQL script which I then import into an Excel spreadsheet. One of the columns is numbers and I format the column as "Number" with two decimal places. When I create the Pivot Table only one of the criteria fields (ATM)will give me a total. The other two fields keep amounting to zero. I've even tried to skip the Pivot Chart and just insert Sub-Totals into the spreadsheet choosing to insert the total after each change in criteria type; but still only one type of criteria will ...

Creating Date Range in Pivot Microsoft Query
I have a pivot that I've connected to our SQL db using the MS Query. I'm having two problems with it: 1. In Access I create a date range to see dates between 3 and 15months ago with the SQL statement " WHERE (Trx.TrxDate) Between (Date()-485) AND (Date()-120)" - no problem in Access but not the MS Query program. When I do it through the Excel MS Query it says the Function 'date' is not valid. How do I describe the current date in the MS Query program? 2. In the same wizard I cannot combine two fields (in Access I would use Expr1: [Field1]&", "...

Delete row if value cobtains a dot
I have two types of values in a column. One that contains a value with a dot (GB2-E0031.02) and one that does not contain a value with a dot (GB2-E0031) I would like to delete the whole row If the value in column B does not contain a dot (.) Many thanks in advance. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-new/200605/1 1) Select the column 2) Go to menu data/filter/auto filter 3) In the dropdown list of criteria, select custom... 4) In the criteria setup, select "Contains" and type "." as value 5) This will show only those rows whi...

Group Policy for Different Time Zones
How do you setup in Active Directory for Windows 2003 server a group policy for an OU whose users are located on the east coast when the AD is located in Phoenix so that their time zones are reflective of their location for Outlook calendars, reminders, emails, etc....? Thus if I'm in New York and want to schedule a 4:00pm meeting with someone in Phoenix where the meeting time for them will be 1:00pm and we both are using the same AD on the same server but under different OUs how do we get Outlook calendar to schedule the meeting for each of their respective time z...

Transfer a calculated value from one report to another
I had 2 reports that use different row format and different column format eg: repor1 is using row1 and col1, where as report2 is using row2 and col2. How can I transfer a partiulcar calculated result from report1 to report2 as report2 uses that value in some calculation. thks If this is in Report Writer then I would say No but if its in Crystal Reports then you can copy the formula. -- http://ddelprado.blogspot.com "HFLo" wrote: > I had 2 reports that use different row format and different column format > eg: repor1 is using row1 and col1, where as report2 is using row...

Outlook 2003 from SBS different from Office 2003?
I have an SBS2003 server installed and distributed the Outlook2003 that came with it to my clients, while the other office applications still ran the 2000 version. Last week, we installed the office 2003 suite and I disabled the installation of Outlook 2003, since it was already installed. Next I installed the Rights Management Server and the client. All Office applications now have the Permissions icon, except Outlook. I have looked through every single setting, but could not find how to enable it. This leads me to conclude that the SBS outlook 2003 version might be different from t...

how do I combine two forms with different size columns to make on.
I built two forms to make one as I cannot control the difference in columns sizes. Now I cannot merge the two forms to make one. Is this possible or have I wasted hours. I am fairly new to forms. Thank you Hi not sure what you mean by "forms", if you're talking about laying information out in a worksheet, then you can not change column sizes within the same column ... ie the size of column A is applicable to all 65536 rows. However, a "workaround" is to merge adjacent cells (format / cells - alignment tab, merge cells) ... however, merging cells can cause pr...

Restore Database to new server with different name. Is it possible?
I have a situation where we need to go back to view old information from an exchange backup (server A) from 3 months ago. (Server A) is still online. Of course I know I am going to need to build exchange on another server but does this temp exchange server need to have the same name as (server A) for me to view the data? Monica: Yes, it's possible and commonly done. No, you don't need to have the same server name, or even the same domain name. Please refer to http://www.microsoft.com/exchange/ for articles on restoring Exchange. Regards, Martin "Monica White" <an...

PIVOT TABLE FORMULA #2
I have a pivot table with lot s of companies name. Each company has only one country associate. I need to do a calculated item formula but when I do this something happened because now each company is being associate to all countries and this is not correc. Is there any way fix this ...

hiding certain columns in pivot table
Hello, I have a pivot table that I have inserted a calculated column which appears for every column. I'm just wondering if there's away to hide particular calculated columns in a pivot table. I'm only interested in the calculated figure for one particular column and what to hide the figure for the rest of the columns. Thanks, Alan ...

Table no longer copies formulas to new rows
It's 32-bit Excel 2010. I have a table of date, deposit, withdrawal, balance, and some other columns. Previously if I entered a date in the next row, the formulas automatically propagated themselves to hat new row; now hey don't. I don't know what I did to cause that change, but I'd be grateful for guidance. I tried resizing the able to contain all the existing rows, but that didn't help: when I add a new row the formulas still don't copy from the row above. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA h...

Screen View differs from Print preview
I know this is basic, but I REALLY need help. I have a colum with text wrapping selected. As I type in the cells, two things happen. 1) It might be on three lines on the screen, but when I print preview it is only on two. It is as if the print preview cell in larger. 2) Also, words may not show up on the screen in the cell, but when I print preview they are there. i just want what I see on the screen to match what is on print preview. Any suggestions would help. Thanks. This is a problem with Excel, Jennifer, and I don't think there is a good answer. Excel's text wrap is just n...

Table Open Error
I am running Great Plains Ver 6.0. I installed a new client but when they print a report from an open table, they get "An open operator on table GL_Account_MSTR has an incorrect number of keys" Then I get a second window that says "Table Open Error". Other users work fine. I tried copying the Dynamics.set file, but the same error. Any suggestions would be appreciated. Thank you Rich It sounds to me like your Dynamics.dic dictionary has not been properly synchronised with your account framework and additional sorts. You can change the Synchronize=FALSE to Synchroni...

Looking for a loan calc spreadsheet, one that if you make an extra payment, it will calculate into the duration
Anyone have one of these? I would like one to use with my mortgage and my car loan. I always pay a little extra each month, so I would like to now what these payments will do in the long run. THanks in advance. Make a simple loan amortization table. The following assumes that you are not making extra payments, just paying extra on regularly scheduled payments - Put the loan amount in C1 - Put the annual interest rate in D1 - In D2 divide D1 by the number of payments per year (=D1/12 for monthly payments) - In A2 put =ROW()-1, as a payment counter (or some other payment ID that might ...

Report Showing Different U of M
Is there a report where I can see my item numbers not in the base unit of measure? For example, see items by 'case' as opposed to 'each'. Thanks in advance! Craig YES! It's a 3rd party solution and I'm being worthless tonight beause I can't recall the name. Hopefully someone will be able to help me out. It does exist, I've seen it and used it. Let me know if nobody comes through with the vendor and I'll hunt it down fo you. leslievail@earthlink.net LV "Craig" wrote: > Is there a report where I can see my item numbers not in the ba...

max column and row
Is the maximum column name IV ? If i open a workbook and right arrow until it stops, that's the column name If i try Insert column it doesn't change so i'm guessing that's the maximum? likewise max row appears to be 65536? thanks mark Entering "specifications" into Excel help gets you "Excel specifications and limits" and the answer to your question. (plus other stuff that will be on the test <g>) -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (Thesaurus for Excel - in the free folder) "mp" <nospam@T...

How do I change the date format in a pivot chart from numbers to a
...

Difference in years of 2 dates (COleDateTime)
Hello! I need to take the difference of two dates in years, lets say -> 12/5/2003 and 12/5/1980 now...the difference should be 23 years right? When I calculate the difference I am getting 22 years...Is there something I am not taking into consideration here? COleDateTime bday(1980,12,5,0,0,0); COleDateTime today(2003,12,5,0,0,0); int bday_day=bday.GetDayOfYear(); int today_day=today.GetDayOfYear(); TRACE1(_T("%d days\n"),bday_day); TRACE1(_T("%d days\n"),today_day); This results in -> 340 days into...

can not open linked table
When trying to open a linked table I get an error message that the file is opened exclusivelyby another user. I have used this link before many times and have knowingly done nothing to change it. I am using acces 2007 on a vista lap top to an access 2000 database on a different computer (xp) which uses access 2000 . If you are certain that you are the only user, close Access and delete the LDB file on the remote computer. If there is more than 1 user, 1 or more have the database opened exclusively. Go to Options on each computer using the database, and change that. "jnacces...

how to pull a record to a form and save it to another table
hi, I want to pull data from more then one field ( as it seems with a combo box with multiple fields listed in a row ) and have it save these fields to a diffrent table. What I'm trying to do is take a Whole record and save that record to a new table. Thanks L Why? It's seldom a good idea to store redundant copies of data. You can use an INSERT INTO query: Dim strSQL As String strSQL = "INSERT INTO TheOtherTable(Field1, Field2, Field3) " & _ "VALUES(" & Me.txtNumericField & ", """ & _ Me.txtTextField...

using data tables to create XML
So I created my dataset class. Then added my datatables and the columns to the data tables. What I want to do is when I fill the datatable have one of the columns be another datatable so that I can create my complex type when I get the XML. So lets say I have two tables Stop_Location and Stop_Address Table Stop_Location Column Stop_Name Column Stop_City Column Stop_Address Table Stop_Address Column Stop_Address1 Column Stop_Address2 Then when I fill table Stop_Location I would like Stop_Address to actually be the columns from table Stop_Address. I tried to mak...

different CELL FORMATS?
While saving individual file to one Excell fill " Too many different cell formats" comes up and it will not let me exit without close the entire file. I'm using Windows XP Hi for dealing with too many cell formats have a look at the following KB article http://support.microsoft.com/default.aspx?scid=kb;en-us; -- Regards Frank Kabel Frankfurt, Germany "Msladibyrd" <Msladibyrd@discussions.microsoft.com> schrieb im Newsbeitrag news:FE5786BA-C7F3-48A0-BE56-67E924A75B25@microsoft.com... > While saving individual file to one Excell fill " Too many differen...

switching mailbox to a different user.
is it possible to take a mailbox and attach it to another user? I need to create a user and take a mailbox that is attached to a different user and somehow attach it to the new user I am creating. On Thu, 3 Nov 2005 11:14:04 -0800, "Tyson" <Tyson@discussions.microsoft.com> wrote: >is it possible to take a mailbox and attach it to another user? I need to >create a user and take a mailbox that is attached to a different user and >somehow attach it to the new user I am creating. Yes. Make sure you have Deleted Mailbox Retention enabled on the store for more than...

Read XML file as an Access table?
Is there any way to process an XML file as an Access table or does the XML have to be imported to a table first? I did some experiments and XML processing appears to be extremely slow; is there any way to speed it up? Thanks. ...