Hi Chris

If you hover over the Data button in your PT, it will change to a cross.
Hold the left mouse button down and drag the data button to the Total Column
and you will then see your tests side by side.
Is this what you want?

Regards

Roger Govier


Chris Segrave wrote:
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!!!!!