Pivot table with empty cells (no value displayed)

asked 2019-12-04 22:55:52 +0100

Hi, I am working on the Geographical Names database of Canada (350 000 lines) and want to organize the data to know how many names have been created by year, by province and by place category (cities, lakes, etc.). I successfully created the pivot table with the appropriate parameters, and I get a table with the right columns and lines. But there are no value displayed in the table, and I can't figure out why.

Libre Office Calc is 6.3, Windows 10, on a brand new PC.

Thanks for your help, here are screenshots : C:\fakepath\screenshot2.png C:\fakepath\screenshotemptypivot.png

edit retag flag offensive close merge delete


Could you upload you file? - hard to tell what's wrong without the raw data.

Opaque gravatar imageOpaque ( 2019-12-04 23:01:18 +0100 )edit

Hi, thanks for getting back . I can't upload the file here cause too big, but here is where I've downloaded it : ftp://ftp.geogratis.gc.ca/pub/nrcan_rncan/vector/geobase_cgn_toponyme/prov_csv_eng/cgn_canada_csv_eng.zip . I made sure that all data are numbers and not text but I still have the same issue of values not displaying in Pivot table.

alfinouille24 gravatar imagealfinouille24 ( 2019-12-05 11:34:47 +0100 )edit