pivot table trouble

[anandvarma]

Hi

I have data set, i have generated a pivot table,
the table is as follows:

Excel Workbook
	I	J	K	L	M	N	O	P	Q	R	S
1	Vehicle Type (Category)	2
2
3	Count of Trip frequency	Column Labels
4	Row Labels	2	5	6	7	8	9	10	17	22	Grand Total
5	1	2	0	2	91	0	4	11	0	2	112
6	2	0	0	0	1	0	0	0	0	0	1
7	3	0	0	0	6	0	2	2	0	0	10
8	4	0	2	27	230	0	2	47	2	6	316
9	5	0	2	216	115	2	0	32	0	4	371
10	6	0	0	0	4	0	0	0	0	0	4
11	7	0	0	0	1	0	0	0	0	0	1
12	9	0	0	0	4	0	0	0	0	0	4
13	10	0	0	2	0	0	0	0	0	0	2
14	11	0	2	0	38	0	6	45	0	2	93
15	12	0	0	0	3	0	0	0	0	0	3
16	13	0	0	0	1	0	0	0	0	0	1
17	15	0	0	0	2	0	0	0	0	2	4
18	16	0	0	0	0	0	0	2	0	0	2
19	17	0	0	0	8	0	2	14	0	8	32
20	18	0	0	0	4	0	2	8	0	0	14
21	19	0	0	0	0	0	0	0	0	2	2
22	20	0	0	0	0	0	0	2	0	0	2
23	21	0	0	0	2	0	0	0	0	0	2
24	Grand Total	2	6	247	510	2	18	163	2	26	976
Data

if you see row numbers are generated 1,2,3 etc up to 21 but there are some missing numbers 8, 14 etc,

this is happening because values are zero, pivot table is not considering this and that row is not generated in table

same thing also happening in columns also

please suggest

anand varma

 

[Barbara Excel]

Hi

it looks me me like you are not displaying the zeros in your data.
In the pivot table, double-click on the Type button in the row area.
Add a check mark to 'Show items with no data', then click OK


Hope that helps

Barbara Excel

 

[anandvarma]

Hi

it looks me me like you are not displaying the zeros in your data.
In the pivot table, double-click on the Type button in the row area.
Add a check mark to 'Show items with no data', then click OK


Hope that helps

Barbara Excel

Dear Barbara Excel

i could not able to find type button

can you tell me step by step

anand varma

 

[Barbara Excel]

anand varma

heres how to show items with no data

Go onot your pivot table wizard, hit layout In your 'row' area, double click the row item, this will bring up the pivot table field box.

At the bottom of this is 'show items with no data'- you need to tick this

Barbara Excel

 

[anandvarma]

anand varma

heres how to show items with no data

Go onot your pivot table wizard, hit layout In your 'row' area, double click the row item, this will bring up the pivot table field box.

At the bottom of this is 'show items with no data'- you need to tick this

Barbara Excel

Dear Barbara Excel

I could able to find the "show items with no data" button, but that is disabled

any help

anand vamra