Make sure there is an origin brush on the edge of the door. this is how the door "knows" from what point to make the rotation. Also, the default axis for func_rotating is z, but you can make it rotate on any axis.
Check entity guide, tutorials, map vault examples, and forums for more information.