calculated fields pivot table - i am lost

  • Thread starter Thread starter MD
  • Start date Start date
M

MD

the problem is the following:

i am having data records in a table with a name column, value columns, etc.
creation of pivot table works fine - sums are shown. No i would like to
insert a calculated field - calculating a sum of values from two different
columns - works fine but the subtotal/grandtotal figure below the new column
is not the sum, but a product as well.

Is there any way to get a sum instead for the subtotal/grandtotal of the
calculated column? Is there any other way to provide the same results?

thanks in advance
 
Hi

The Grand Total filed will use exactly the same logic as you applied to
the calculated field. It will not sum the values of the column
containing the calculated field results.
I think you will need to insert another column in your source data, to
carry out the calculation, then drag this new column as a filed into
your data area, and delete the PT calculated field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table calculated field Count(field) / sum(field) 0
pivot table calculated field 1
Sub Totals as a calculated field in a pivot table 2
Calculated Field in Pivot Table minimum value 0
Excel 2007 Pivot Table - Problem with custom field? 2
Displaying a count as a percentage within subtotals in a pivot tab 1
Pivot Table question: Creating a new field that calculates thedivision of one data field by another 4
How to set cell value to emptry if three other columns are empty too 1

Back
Top