Oracle Error QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET

Oracle Error Message

QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET

Reason for the Error

The capability in question is not supported when the expression is not in the PARTITION BY clause

Solution

Change the query so that the expression is in the PARTITION BY