Pivot table with empty cells (no value displayed)

[alfinouille24]

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 :

(Edit: activated screenshots -AK)

[anon73440385]

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

[alfinouille24]

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.