I use the following pivot query in Access database to track the daily work rate of 9 teams:
TRANSFORM Count(Master.Actual) AS Units
FROM Teams INNER JOIN Master ON Teams.ID = Master.Teams_ID
WHERE (((Master.Actual) Is Not Null))
GROUP BY Master.Actual
This gives me the dataset in the attached picture..
I have spent way too long trying to add a row to the bottom of that dataset to show the totals..can anyone help / explain? (i am aware there is a totals button in Access 2007 but this is not the solution)
Thanks for reading
For row totals, add the value field again as a row heading.