The custom distribution is used under these conditions:
It is a flexible distribution, used to represent a situation you cannot describe with other distribution types.
It can be continuous, discrete, or a combination of both and can be used to input an entire set of data points from a range of cells.
For an example of a custom distribution, see the ClearView tutorial (Growth Rate Assumption: Custom Distribution). Also see Using the Custom Distribution.