Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Calculated Field using Grand Total
I have a pivot table of sales data. I need to have a calculated field that
gives me my sales mix. In an excel cell the formula would be =(2007%of Revenue)*(total2008Sales$) I have fields in the current PT that give me the % of revenue, and the sales numbers, but I do not know how to tell the PT how to find the total 2008 sales number (not just the sum of sales for that specific catagory) Hope this is clear... thanks Diane |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Calculated Field using Grand Total
I have used this site before and have always gotten very quick, thourough and
accurate responses..Thank you thank you! So, is the lack of response to this due question to the fact that *my request is not possible, *we don't know, or *we don't understand what you are asking. Thanks Diane "diaare" wrote: I have a pivot table of sales data. I need to have a calculated field that gives me my sales mix. In an excel cell the formula would be =(2007%of Revenue)*(total2008Sales$) I have fields in the current PT that give me the % of revenue, and the sales numbers, but I do not know how to tell the PT how to find the total 2008 sales number (not just the sum of sales for that specific catagory) Hope this is clear... thanks Diane |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Calculated Field using Grand Total
You can't tell a calculated field to use the total sum, so it will
always use the sum for the specific category. Perhaps you can accomplish this with GetPivotData formulas outside of the pivot table. diaare wrote: I have a pivot table of sales data. I need to have a calculated field that gives me my sales mix. In an excel cell the formula would be =(2007%of Revenue)*(total2008Sales$) I have fields in the current PT that give me the % of revenue, and the sales numbers, but I do not know how to tell the PT how to find the total 2008 sales number (not just the sum of sales for that specific catagory) Hope this is clear... thanks Diane -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Calculated Field using Grand Total
May be easier if you add
a helper column to the PT source data: http://www.savefile.com/files/1548235 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect total of calculated field in pivot table | Excel Discussion (Misc queries) | |||
Using '% of Total' in calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Missing Grand Total for a Calculated Field in a Pivot Table | Excel Worksheet Functions | |||
Erroneous Grand Total of calculated fields in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Field (Grand total question) | Excel Discussion (Misc queries) |