Using a field outside a pivot table

[cmbyates]

I would like to place a field [% increase] outside of my pivot table which could be used within a calculation within the pivot table to create a "what if" scenario such as Sales * [the % increase]. I haven't been able to see how to refer to an external field. Any help would be appreciated. Cindy

 

[Somendra Misra]

Hi cmbyates,

Why dont you insert a calculated field inside your pivot table as %increase?

Regards,

 

[cmbyates]

I

Hi cmbyates,

Why dont you insert a calculated field inside your pivot table as %increase?

Regards,

If I use a calculated field, does the user have to go into that calculated field to change the value? I was trying to keep it simple for end users without a lot of experience?

 

[Somendra Misra]

Hi,


Why not upload a sample file and explain your idea?

Regards,