Pivot Table

[sganti]

Hi Kindly Help me with this.
I am building a pivit table.
3 variables.

X : Page Field. Available values: 5,10,15,20
Y: Column Fileld. Available values: 1,2,3,4
Z: Data Field : Sum of Z.

Now, In one single pivot table, I want to show the following:

a) For Column values 1 and 2, I want to show the sum of Z b
considering all values of Page field : X (5,10,15,20).

b) But, for column values 3 and 4, I want show the sum of Z by
considering only 15 and 20 of X.


Can you please help me.

y x z
1 5 2
1 10 4
1 15 6
1 20 8
2 5 1
2 10 0
2 15 0
2 20 10
3 5 3
3 10 6
3 15 9
3 20 12
4 5 4
4 10 8
4 15 12
4 20 1

 

[Dave Peterson]

In your pivot table, you can choose which values to show for the X category. So
when you show the Y=1 or 2, you could just click on the header for X and show
all values.

But if you show y=3,4, you could just show the x fields of 15 and 20.

Or you could insert another column in your raw data.

=if(or(a2=3,a2=4),b2,0)

Give that nice label and use that in your pivottable.