| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Variances using Pivot Table
Hi,
I am trying to find the variance % between the data using different months. I was unable to figure out how I can show the variance by % using the Pivot Table. For example: Current Data Desc 01/01/2007 02/28/2007 03/31/2007 Ticket Sales $100.00 $120.00 $97.00 Looking for results: Desc 01/01/2007 02/28/2007 Change in % 03/31/2007 Change in % Ticket Sales $100.00 $120..00 +20% $97.00 -19% Any suggustion? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Variances using Pivot Table
Hi
Drag another copy of your Data filed to the Data area. Double click on field headerAdvancedShow Data as%Difference from Previous On the PT, drag the Data icon and drop on Total so he values show side by side. -- Regards Roger Govier "IF Statement" wrote in message ... Hi, I am trying to find the variance % between the data using different months. I was unable to figure out how I can show the variance by % using the Pivot Table. For example: Current Data Desc 01/01/2007 02/28/2007 03/31/2007 Ticket Sales $100.00 $120.00 $97.00 Looking for results: Desc 01/01/2007 02/28/2007 Change in % 03/31/2007 Change in % Ticket Sales $100.00 $120..00 +20% $97.00 -19% Any suggustion? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Variances using Pivot Table
Thank you Roger.
Could you clarify "drag the Data icon and drop on Total" how this can be done. Which total do you mean? Please advise. "Roger Govier" wrote: Hi Drag another copy of your Data filed to the Data area. Double click on field headerAdvancedShow Data as%Difference from Previous On the PT, drag the Data icon and drop on Total so he values show side by side. -- Regards Roger Govier "IF Statement" wrote in message ... Hi, I am trying to find the variance % between the data using different months. I was unable to figure out how I can show the variance by % using the Pivot Table. For example: Current Data Desc 01/01/2007 02/28/2007 03/31/2007 Ticket Sales $100.00 $120.00 $97.00 Looking for results: Desc 01/01/2007 02/28/2007 Change in % 03/31/2007 Change in % Ticket Sales $100.00 $120..00 +20% $97.00 -19% Any suggustion? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Variances using Pivot Table
There's a description, with a picture, he
http://www.contextures.com/xlPivot02.html IF Statement wrote: Thank you Roger. Could you clarify "drag the Data icon and drop on Total" how this can be done. Which total do you mean? Please advise. "Roger Govier" wrote: Hi Drag another copy of your Data filed to the Data area. Double click on field headerAdvancedShow Data as%Difference from Previous On the PT, drag the Data icon and drop on Total so he values show side by side. -- Regards Roger Govier "IF Statement" wrote in message ... Hi, I am trying to find the variance % between the data using different months. I was unable to figure out how I can show the variance by % using the Pivot Table. For example: Current Data Desc 01/01/2007 02/28/2007 03/31/2007 Ticket Sales $100.00 $120.00 $97.00 Looking for results: Desc 01/01/2007 02/28/2007 Change in % 03/31/2007 Change in % Ticket Sales $100.00 $120..00 +20% $97.00 -19% Any suggustion? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Variances using Pivot Table
Thank you Debra. This is excetlly I was looking for.
"Debra Dalgleish" wrote: There's a description, with a picture, he http://www.contextures.com/xlPivot02.html IF Statement wrote: Thank you Roger. Could you clarify "drag the Data icon and drop on Total" how this can be done. Which total do you mean? Please advise. "Roger Govier" wrote: Hi Drag another copy of your Data filed to the Data area. Double click on field headerAdvancedShow Data as%Difference from Previous On the PT, drag the Data icon and drop on Total so he values show side by side. -- Regards Roger Govier "IF Statement" wrote in message ... Hi, I am trying to find the variance % between the data using different months. I was unable to figure out how I can show the variance by % using the Pivot Table. For example: Current Data Desc 01/01/2007 02/28/2007 03/31/2007 Ticket Sales $100.00 $120.00 $97.00 Looking for results: Desc 01/01/2007 02/28/2007 Change in % 03/31/2007 Change in % Ticket Sales $100.00 $120..00 +20% $97.00 -19% Any suggustion? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| create pivot table from excel table | Excel Worksheet Functions | |||
| pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
![IF Statement[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
