I am having a problem with pivot table.
Suppose I have the following values
A B C
a x 1
a y 12
. . .
. . .
b x 4
b x 5
. . .
. . .
c y 4
. . .
I am doing a pivot table by keeping A & B in column values and summing C in data. I want to get all B values for A column. for eg.
in this case we won't get y for b and x for c.
I know we can put B column in row to get all B values in PT. But if we have an one more variable in row we will have a problem...
Suppose I have the following values
A B C
a x 1
a y 12
. . .
. . .
b x 4
b x 5
. . .
. . .
c y 4
. . .
I am doing a pivot table by keeping A & B in column values and summing C in data. I want to get all B values for A column. for eg.
in this case we won't get y for b and x for c.
I know we can put B column in row to get all B values in PT. But if we have an one more variable in row we will have a problem...