How to add new field in pivot table,which doesn't refer to source
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 |
How to add new field in pivot table,which doesn't refer to source
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. On Mar 25, 9:30 am, Vinod wrote: 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 |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com