Pivot Table issue - what am I doing wrong?

wolfster

New Member
Joined
Oct 29, 2005
Messages
6
Hi All

I am running Excel 2002 (10.6501.6626)SP3. My problem is as follows.

How does one create an extra row in a pivot table where one can perform a calculation, I could do it on an earlier version of Excel, but can't find that option here. In the earlier version, the option was create calculated field/item

I need to do this:
the one row contains items sold.
the next row contains return items
the third row must contain the return percentage (return items/items sold)*100

Any ideas.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I have Excel 2000 rather tha Excel 2002, but it may be the same. Right click in the Row field and choose Formulas|Calculated Field.
 

wolfster

New Member
Joined
Oct 29, 2005
Messages
6
Hi Andrew

Thanks for getting back to me! I afraid I don't see that. I must be a complete ignoramous if I'm still missing it, I don't see it. I checked Excel help, but this was not too helpful
How can they consider a customer calculation when one cannot specify exactly what one needs. In a previous excel version it was a **** breeze :0) I can't believe they left it out???

The following functions are available for custom calculations (custom calculation: A method of summarizing values in the data area of a PivotTable report by using the values in other cells in the data area. Use the Show data as list on the PivotTable Field dialog for a data field to create custom calculations.) in data fields (data field: A field from a source list, table, or database that contains data that is summarized in a PivotTable report or PivotChart report. A data field usually contains numeric data, such as statistics or sales amounts.).

Function Result
Difference From Displays data as the difference from the value of the Base item in the Base field.
% Of Displays data as a percentage of the value of the Base item in the Base field.
% Difference From Displays data as the percentage difference from the value of the Base item in the Base field.
Running Total in Displays the data for successive items (item: A subcategory of a field in PivotTable and PivotChart reports. For instance, the field "Month" could have items such as "January," "February," and so on.) in the Base field as a running total.
% Of Row Displays the data in each row or category as a percentage of the total for the row or category.
% Of Column Displays all the data in each column or series as a percentage of the total for the column or series.
% Of Total Displays data as a percentage of the grand total of all the data or data points in the report.
Index Calculates data as follows:
((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))
 

wolfster

New Member
Joined
Oct 29, 2005
Messages
6
Hi Andrew

**** sure it helps! Thank you kindly! If you ever head on down to Cape Town/South Africa, drop me a pm, I owe you a coupla beers!

Cheers
wolfster
 

Forum statistics

Threads
1,078,373
Messages
5,339,814
Members
399,332
Latest member
weeyang86

Some videos you may like

This Week's Hot Topics

Top