Calculations in pivot table

[Guest]

I just made my first pivot table. One column is a pivot-table-generated
"Total". I want to add a column that is the product of Total and another
pivot table column, but can't seem to figure out how to do this. Help says
something about not being able to use Totals in calculations. Is there a way
around this?

To make my question clearer, here's an example of what I'm trying to do.
The pivot table makes the first three columns, counting occurrences of defect
type and Severity and producing a count it labels "Total". What I want to
add is a Weighted Occurrences column that multiplies Severity by Total (see
below). I can't get this last cell to work.

Defect Weighted
Type Severity Total Occurences

Z 0.01 5 .05

Y 0.1 7 0.7

X 1.0 2 2.0

 

[Roger Govier]

Hi
With Type as a row Item and Severity as a row item, Count of Severity as a
Data item.
From the Pivot Table toolbar, dropdown on Pivot table and Select
Formulas>Calculated Field
Title the Field Weighted Occurrences
In the Formula pane type =Count(Severity)*Severity
Add the field to the Data area.
If the new field shows under the original, drag the heading Data, and drop
it on Total and you will get the columns side by side as you require.


Regards

Roger Govier

 

[Debra Dalgleish]

Assuming Severity is a numeric field, if you add another copy of
Severity to the data area, as Sum of Severity, you should get the result
that you want.