Pivot Table - cubed detail
 

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!!!!!

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!!!!!

Hi Roger,

not really.... i have set the pivot so the data goes across the columns
already..

what i'm looking for is basically to be able to choose the outcome of the
test, whether it's 1 2 3 or 4, having all 4 tests on the same sheet. i've
got it currently over 4 sheets, with the column headings across the page, and
i can choose whether i want to see all 0's or 1's etc. only, not all data....

any idea's

thanks...

R,
Chris.


"Roger Govier" wrote:

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!!!!!