Cabaret (1972 film) Buy at amazon
Director: Bob Fosse.
There are many films on showgirls, this is the most revealing.