Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat pivot row or approach to refer to pivot field value... | Excel Discussion (Misc queries) | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Pivot Table Row Field Format (OLAP Source) | Excel Discussion (Misc queries) | |||
How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) | |||
Field Source Error for Pivot Table | Excel Worksheet Functions |