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

  • Thread starter Thread starter Vinod
  • Start date Start date
V

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
 
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.
 
Back
Top