Pivot table - adhoc formula

[TomMagee]

Can I develop a formula that I can add to those which you pick from whe
using the wizard ie sum, average, min, max etc

Specifically, I want to add an IF statement to give me a 'flag' i
which to summarize the data with elsewhere. The data behind the pivo
changes (sales data) and I am trying to flag new customers that hav
never worked with us before.....once they have traded with us then the
dissappear as they are now an old customer


To

 

[Frank Kabel]

Hi
no you can't do this

 

[Debra Dalgleish]

You can create calculated items and calculated fields in the pivot
table, but this sounds like something that you could add as a field in
the pivot source table. Then, add that field to the pivot table's row area.

 

[Dave Peterson]

Why not put the flag in the raw data. Then either include it as a row field or
even a page field?

Or you may want to look at Debra Dalgleish's site:
http://www.contextures.com/xlPivot06.html

For using formulas with your existing pivottable.