I would like to add a grand total column (total number of students) to a pivot table the pivot table uses count(studentid)DECLARE @SLOAchievement nvarchar(1000)SELECT @SLOAchievement = STUFF( ( select ',[' + AchievementLevel+ ']' from SLO. OrgAchievementLevel where OrgID=@OrgID