calculated field in a pivot table
 

hello everybody,
let's suppose i have a value in a cell and i want to use that value to
create calculated field in a pivot table,
how can'I put the value of this cell in a variable which can be used in
a pivot table?
thanks folks.

calculated field in a pivot table
 

There's no built in way to use a cell value in a calculated field formula.

Akramx wrote:
hello everybody,
let's suppose i have a value in a cell and i want to use that value to
create calculated field in a pivot table,
how can'I put the value of this cell in a variable which can be used in
a pivot table?
thanks folks.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html