Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!!! |
#2
|
|||
|
|||
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!!!!! |
#3
|
|||
|
|||
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!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot table subtotals before detail | Excel Discussion (Misc queries) |