I would like to know if the Pivot Table can calculate the difference between
two columns of data for me. For example, I have the amount of loans in
December in column A and the amount of loans in January in column B and I
would like to see the increase or decrease. THe way I've been doing this is
manually entering in the calculation.
Thanks in advance!
Debra Dalgleish explains lots at:
www.contextures.com/xlPivot10.html
Karen wrote:
gt;
gt; I would like to know if the Pivot Table can calculate the difference between
gt; two columns of data for me. For example, I have the amount of loans in
gt; December in column A and the amount of loans in January in column B and I
gt; would like to see the increase or decrease. THe way I've been doing this is
gt; manually entering in the calculation.
gt;
gt; Thanks in advance!
--
Dave Peterson
- Aug 14 Mon 2006 20:08
Calculate Difference between 2 columns in Pivot table
close
全站熱搜
留言列表
發表留言