For example, if it relates to sales - I want to define my own performance status based on sales revenue and the number of days since the last sale. I've currently done this using nested IF formulas in a helper column to return the number 1, 2 or 3 and applying conditional formatting as red, green amber. However I can't sort the pivot table itself based on this.

What's the correct way to do this so that it appears as a column in the pivot table? Thanks