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