Hi all.. PLEASE HELP!!!

i'm trying to create a pivot table to display some cubed data (sort -of)..

this is an example of the data...

brand model parent compartment test 1 test 2 test 3 test 4
brand 1 model 1 parent 1 compartment 1 0 1 0 0
brand 3 model 1 parent 1 compartment 2 1 0 0 0
brand 1 model 1 parent 1 compartment 1 2 1 1 0
brand 2 model 1 parent 3 compartment 3 4 3 2 5
brand 4 model 2 parent 2 compartment 2 3 1 5 1

my current pivot table looks like this

page field:
parent
compartment

row field: data
brand test 1
model test 2
test 3
test 4

my question is: how can i count all test results as 1, 2 ,3 ,4 & 5 per
brands and models and be still be able to drill down on page fields????

currently the best i can do is count the total number of tests, or sum the
results, not group them by the result category.....

any help would be very much appreciated!!!!!