help with crosstab or pivot function

[webicky]

Currently, I have a two way Pivot and would like to add a third
layer:
Is that possible?

What I have gives me Score by Grade and Test with the scores at each
grade/test level. I'd like to add the Sum at each grade/test level
(var name: Students Tested) as well.


Here is what I have:
TRANSFORM Sum([Final table: Gr6-8, Subgr1 - test 7,8,9,11].[Score])
AS
theValue
SELECT [Final table: Gr6-8, Subgr1 - test 7,8,9,11].p_id, [Final
table: Gr6-8, Subgr1 - test 7,8,9,11
FROM [Final table: Gr6-8, Subgr1 - test 7,8,9,11]
GROUP BY [Final table: Gr6-8, Subgr1 - test 7,8,9,11].p_id, [Final
table: Gr6-8, Subgr1 - test 7,8,9,11].[Matching xyz], [Final table:
Gr6-8, Subgr1 - test 7,8,9,11].name, [Final table: Gr6-8, Subgr1 -
test 7,8,9,11].d_name
PIVOT [Grade] & "." & [Test];

I have a second table pivoted the same way, but was hoping to get them
all into 1 query TRANSFORM Sum([Final table: Gr6-8, Subgr1 - test
7,8,9,11].[Students Tested]) AS [SumOfStudents Tested]

Is there a way to do this?

Thanks!