Hi, i want to show a different background color if number of meetings per week is over or below let's say 30% of the average per week. I can't find a way to get the right expression in the background color for the expression in a pivot table. Help much appreciated, Zach.
Hi, thanks for your help. I'm not there yet. What i need is an average calculation per row (per RoomID) over the weeks. For example: for RoomID 100 the numbers 10, 4 and 3 (the first three weeks) should have the red background color. This, since the average is 6 (24/4) and the upper bandwidth is 6*1.3=7.8 and the lower bandwidth is 6*0.7=4.2. So only the 7 (week 2013-5) should have a normal background color. Is this doable, that each row has it's own average inside the pivot table? Thanks again, Zach