Calculated Field in Pivot Table

[Fev]

Hi
I am building a Pivot Table to create projections for sales figures
based on previous sales. I have added a calculated field that uses
the following If function: =IF('Previous Year'<=1000000,'Previous
Year'*1.12,'Previous Year'*0.98) this works fine, however the
subtotals for each product (some products have 2 sizes available) are
using the If test and not adding the actual values together. This is
an example of my results:
Row Labels Next Year
Blance Latte R2,270,495.97 (total for Blance Latte)
50 R2,270,495.97 (Calc using if)
Café Latte R5,524,118.63 (total for both Café Latte prods
- not adding R5,599,675 but using the if test)
50 R604,453.69 (Calc using if)
110 R4,995,221.66 (Calc using if)
Cappuccino R2,875,072.24 (total for Cappuccino should be
R2,999,576)
50 R2,003,544.85 (Calc using if)
110 R996,031.31 (Calc using if)
Cinnamon&Orange R3,778,447.86 (total for C&O calced correctly - both
over 1 mil)
50 R1,221,729.13 (Calc using if)
110 R2,556,718.72 (Calc using if)
How can I get the calculated field to sum the values for the sub
totals and not use the if function to determine the value? It works
if I change the row labels to group by mass, then by name, but would
prefer to have them by name, then by mass.
Thanks
Heather

 

[ShaneDevenshire]

Hi Fev,

Now you need a calculated Item. Select the field containing the Row Labels,
and choose Pivot Table, Formulas, Calculated Item.
Name your formula, then create a formala like =Capachino+Latti+....
You may also want to turn off the pivot table's own subtotal.
The steps above are for 2003 and earlier.