Help required regarding pivot table in excell 2007

[umer.solanki]

I have the Grand

Total for Rows and the Grand Total for Columns checked in the Pivot

Table options, but grand total for rows does not appear when i make a pivot of my data

follwing is link to sample file, please help


Thanking in advance


http://cid-3b12f841946e155a.office.live.com/view.aspx/Sample%20sheet%20for%20pivot.xlsx


https://spreadsheets.google.com/ccc?key=0Ajv5_ncUi5T7dFRIamtaVGp5c2RWWmdoRWNMUW5vUXc&hl=en&authkey=CPDSqd8O

 

[hilcom]

umer,

collect data in a row-way; not in a pivot-way


Country count Categorie

japan 45 MILK

Holland 21 MILK

USA 332 MILK

UK 33 MILK

japan 912 BUTTER

Holland 52 BUTTER

USA 246 BUTTER

UK 35 BUTTER

japan 3 HONEY

Holland 32 HONEY

USA 36 HONEY

UK 3 HONEY


Som van count Kolomlabels

Rijlabels BUTTER HONEY MILK Eindtotaal

Holland 52 32 21 105

japan 912 3 45 960

UK 35 3 33 71

USA 246 36 332 614

Eindtotaal 1245 74 431 1750


sorry for the bad formatting (.)

Bob NL

 

[umer.solanki]

Hi !

It worked like magic, i just reformated my Data, and it was in exact shape,

Thanx a lot for your time and support


Best regards

Umer Solanki