Pivot Tables: Avoiding Cross-tabs (Nesting) in Row Variables

J

Jim

How can I place two variables in the row area so that in
the data area I don't get a cross-tabs (nesting). For
example, suppose I put variables A and B in the row area,
while in the data area is a variable that I want summed.
I want the sum for each value of A and the sum for each
value of B, but I do not want the sum of each combination
of an A-value and B-value. In my intended application,
using a separate Pivot Table for each row variable is not
desirable.
 
K

Ken Wright

I may have read this wrongly, but if you mean you have two sets of data one on
top of the other, and what you really want is the two alongside each other, then
try dragging the grey DATA button over into the Column fields.
 
J

Jim

Maybe I can better explain what I want with an example. I
assume in the example that I have two row variables, A
and B; the A-variable has two values, A1 and A2; and
likewise there are two B-variable values: B1 and B2. I
want the Pivot Table to calculate and display four
numbers: (1) the data field sum for A-variable = A1
(across all values of the B-variable); (2) (1) the data
field sum for A-variable = A2 (also across all values of
the B-variable); (3) (1) the data field sum for B-
variable = B1 (across all values of the A-variable); (4)
(1) the data field sum for B-variable = B2 (also across
all values of the A-variable).
 
Top