Calculate text in pivot as count and make percentage evaluation

Hi,
i try to make pivot where will be automaticaly calculated percent.
I know, that i can use Calculated fields but i want to make percent base count of text.
E.g.
In columnn A i have CITYS. Column B is NAME and column C is DATE.

I make pivot where in rows are DATES. In values are CITYS and NAMES

I made pivot but i want to know withou helping column, in each DATES what for percent in names is in each citys.

I try to calculate filed, but there when i choose fileds like this

Please Login or Register  to view this content.

it makes divide with zero.
I tied

Please Login or Register  to view this content.

but it return 1.

Sorry for my terible english.

Pls. any suggestions?
Thx.

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Which version of Excel do you have? If you have one with PowerPivot, it's easy enough to do. If not, you'll need to add two columns to your source data that return 1 if the relevant field as data and 0 otherwise. You can then sum those fields to effectively count your data, and that you can use in a calculated field.

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks