Conditionally format crosstab cell based on aggregate values for row

[CloseCut]

I have a cross tab report that has categories as the rows and the month/year. Additionally, I have the average and std dev for each row.

for instance:

	2022-01	2022-02	2022-03	AVG	STDDEV
electrical	1	0	2	1	1
mechanical	3	3	3	3	0
admin	1	7	1	3	3.46

Now, I am able to format the cells against a static value. For instance, I can set up a conditional format like this:

Code Select Expand

CellValue () > 2

This will allow me to highlight any crosstab intersection with a value greater than 2.

But I am at a loss on how to get this to work comparing it against the average and/or standard deviation

for instance, the following

Code Select Expand

CellValue ()>[myQuery].[AVG]

highlights nothing, whereas I would have expected this to highlight any cell above average.

My end goal is to highlight any value that is above 1.645 * standard deviation + average, but I cannot even get a simpler rule to work.