Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

[stevenoga1]

I have a pivot table.  The row values are server events (EVENT).  The columns are the range of dates across which the server events were opened(OPEN_DATE).  The measure is a count of the server events opened on each date (TCOUNT)

I want to create a Background Color expression that will cause a cell to turn red if ....  the total number of events opened on that date (TCOUNT) for a given server event (EVENT) exceeds AVG(TCOUNT) + 3* STDEV(TCOUNT) .   

I am pretty new with expressions so any assistance on this would be greatly appreciated. 

[stevenoga1 · Accepted solution]

Solved it...  Thanks

[stevenoga1]

My Solution

=IF (RowNo() <> 0 AND ColumnNo() <> 0

AND Open_Date > MAX(ALL Open_Date)-40    /* only applies equation to the most current 40 days /*

AND SUM(Case_CNT) >= Aggr(Avg(Aggr(SUM(Case_CNT),Open_Date,Standard_Event)) + 3 * Stdev(Aggr(SUM(Case_CNT),Open_Date,Standard_Event)),Standard_Event), Red(), White())