Pivot tables

  • Thread starter Thread starter oa6n
  • Start date Start date
O

oa6n

Is it possible to insert a calculated field that is the absolute valu
of an already existing calculated field. i.e I have a list of value
that are both positive and negative in a pivot table and I would lik
to sort the list by the absolute value each number
 
Create a calculated field that uses the ABS function, and refers to the
existing calculated field. For example: =ABS(Variance)
 
You must log in or register to reply here.

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

Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot table formulas 1
Pivot table filter list - listing irrelevant subcategorys 1
Mystery field in pivot table 8
Delete Pivot Table Formula 1
how do I remove #DIV/0! in a pivot table calculation field ? 2
pivot tables - number of columny but need a column for each month 2
Pivot Table Page Break Refresh Problem 0

Back
Top