value field setting (difference from)

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
Instead of set the calculation formula, can I use the Pivot table value field setting to show the difference between 2 fields?
 

Attachments

  • difference_from.xlsx
    12.5 KB · Views: 13

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,519
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Not unless you modify your source data to have that calculation in one of the fields. The "Value Field Settings" doesn't create new data, it just displays it.

This is easy enough to do with a calculated field though... (attached)
 

Attachments

  • xlgf 1400.xlsx
    12.7 KB · Views: 19
Top