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

I have attached a file for easier understanding. Any help will be greatly appreciated

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

thank you very much claus