Straight table with an average value in the total row - Need to produce a table with average IN the line data
Hi all,
sorry for not being very specific in my title. I have attached my qvw for you to see. Ignore the synthetic keys at the moment! I'll work on cleaning those up. If you look at the Turnover Figures sheet, I have a straight table at the top which shows department, monthly period, with the number of resources employed in that month and the number of resources who have left in that month. I have added an expression to calculate turnover, and then another identical expression which I have totalled as an Average. If I choose one department from a pick list, the bottom row (total line) shows the average correctly.
If I then copy that table, and remove all figures apart from the department and average, the average is not shown as the same figure.
Please can someone have a look at it and let me know how I can get the bottom line average from the first table as a row figure in the second.. I have saved it with the selections to illustrate what I am asking. In the top table the average turnover is 0.00962 I need the bottom table to show this as a line item, but instead it shows 0.0714 Please let me know if you need more info.
