help creating a 3-way pivot

[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 Counts at each grade/test level
(var name: Students Tested) as well.

Here is what I haveL
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];


Is there a way to do this?