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