Hi,
firstly thanks so much for the work you've done in providing the Pivotgrid. It has great functionality straight out of the box and our clients will love it!
My query is about row and column averages. I basically want to be able to highlight specific cells that fall below a row or column average. I know how to use the CellTemplateSelector to change the colour but don't know how to actually find the row, column or overall average so that I have an average threshold to compare the cell value against. For example, take the following grid...
Q1 Q2 Q3 Q4
Fred 2 6 7 9
Wilma 10 10 3 9
How would I work out that Fred's average is 6 (2+6+7+9 / 4) or that the overall average is 7 (2+6+7+9+10+10+3+9 / 8) so that I can highlight the cells falling below the average?
Thanks for any help here : )
Iain.