Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row
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.