Excel Pivot Table Calculated Field RRS feed

  • Question

  • I have the following field om my Database Item_Type, Quantity, Unit_Price.

    I want to design a Pivot Table to sum up Quantities by Item_Type and show the "Total Price" via a Calculated Field called Total_Price= Quantity * Unit_Price.

    When I place the Total_Price calculated field ind the data section next to sum of Quantities that does not give me the correct result.

    Can anybody help?

    Thank you,


    Friday, July 30, 2010 7:04 AM