Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert formula in pivot table
Hi Friends,
I have a pivot table that has "POST CODES". I will need to insert a column in the pivot table to show "STATES". For this I will need do a calculated filed for "STATES" All post codes are stored in text format (for eg-08000). I don't want to convert the text to number, keep it as it is All postcodes beginning with 0 is NT state, 2 is NSW state- list below 0= NT 2=NSW 3=VIC 4=QLD 5=SA 6=WA 7=TAS Can you please suggest a formula Thanks |
#2
|
|||
|
|||
I have attached a file for easier understanding. Any help will be greatly appreciated
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert formula in pivot table
Hi,
Am Fri, 30 Jan 2015 04:17:35 +0000 schrieb Excel Dumbo: |Filename: Book1.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=1002| you can't insert the states as calculated element or field. Try it with a formula beside the Pivot table and format it that it looks like Pivot: https://onedrive.live.com/?cid=9378A...121822A3%21326 Look for "Book1" Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#4
|
|||
|
|||
thank you very much claus
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a blank row in a Pivot table | Excel Programming | |||
how do I insert a row in a pivot table? | Excel Worksheet Functions | |||
Insert formula in a pivot table | Excel Discussion (Misc queries) | |||
PIVOT TABLE HOW TO INSERT....... | Excel Discussion (Misc queries) | |||
Insert a row after a pivot table | Excel Discussion (Misc queries) |