J
Jim
I'm posting this again, with hopefully a clearer
explanation of my need.
In a PivotTable with two row variables and a 3rd variable
to be summed in the data area, the sums are reported in a
nested fashion. What I need is explained in the following
the example using 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
(combined across all values of the B-variable); (2) (1)
the data field sum for A-variable = A2 (also combined
across all values of the B-variable); (3) (1) the data
field sum for B-variable = B1 (combined across all values
of the A-variable); (4) (1) the data field sum for B-
variable = B2 (also combined across all values of the A-
variable).
explanation of my need.
In a PivotTable with two row variables and a 3rd variable
to be summed in the data area, the sums are reported in a
nested fashion. What I need is explained in the following
the example using 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
(combined across all values of the B-variable); (2) (1)
the data field sum for A-variable = A2 (also combined
across all values of the B-variable); (3) (1) the data
field sum for B-variable = B1 (combined across all values
of the A-variable); (4) (1) the data field sum for B-
variable = B2 (also combined across all values of the A-
variable).