Hello all,
The objective here is to color background depending on the average measure per row.
My pivot table is the following:
row = [Activity L3]
Column= [Location (Site)]
Measure= Count(Workbook)/Count(distinct(User ID))
*each activity has certain Workbooks assigned. Workbooks are visited by Users.
I need an expression to do the following:
- Per each row, color background Green() when the measure is bigger than the average total average of the row.
I tried the following with no success:
if(Aggr(Count(Workbook)/Count(DISTINCT([User ID])), [Activity L3], [Location (site)])>=
Avg(Aggr(Count(Workbook)/Count(DISTINCT([User ID])),[Location (site)],)), Green(), Red())
Any help would be great!!
Thanks