I inserted a field =amount1 - amount2 into a pivottable but it doesn't work.
shows diferente result. for instance amount1=10,000 and amount2=3,000 - the
field should show amount1 - amount2... 10,000-3,000 = 7,000 but shows a big
number that doesn't make sense. what i am doing wrong?
mark