How to add new field in pivot table,which doesn't refer to source

[Vinod]

Hi All,

I had a doubt on how to add a new filed in page area of pivot table, but
that filed is not existed in source data.

In other words, I wanted to place new filed called 'MONTHS' in page area of
the pivot table. when the user clicks on dropdown list it has to allow to
select '1Month', '2Month', '3Month'. But this field is not existed in the
source data. Source data has a field 'Periods', contains Jan, Feb, Mar, Apr,
May, June, Jul, Aug, Sep, Oct, Nove and Dec. So, is there any possibility to
add new field like above by using these inputs.

Any one have idea on this, please share it and it would be appreciated.

Regards,
Vinod

 

[Tim879]

Not sure if you can do what you're suggesting above. Why not just take
the easy way out and add the field to your source data?

Just add another column and use a vlookup to change the January to
Month1, etc.