Conversation so far:
Why did Williams leave?
Robbie Williams's drug abuse had escalated to a near drug overdose.
What was the result of this?
CANNOTANSWER.
When did they break up?
On 13 February 1996, Take That formally announced that they were disbanding.
When did they release their greatest hits?
This was followed by the Greatest Hits compilation in 1996.

Question: How did this album do?
Self-contained rewrite: How did the Greatest Hits album do?