Count not selected data

[#1]

Hello,

i have adress data.

I filter all with Name “Maier”

Now i want the Information how many People life in Town (count all for Berlin), how many “Maier” life in town  (count all for “Maier” in Berlin)

these results I want: (but I do not know the functions)

Udo Maier,        Berlin ,      3.500.000, 1

Karin Maier,      Hamburg,  1.800.000,  2

Otto Maier,        Hamburg, 1.800.000,  2

[whiteline]

If you  want to "modify" the selections for a specific expression you can use Set Analysis.

For example. The names are filtered and you want to Count all persons in Berlin.

So you should unselect Name and select Berlin.

With Set Analysis it is =Count({$<Name=, Town={"Berlin"}>} Name)

For more information look for  the words "Set Analysis" in a QV help index.

[Anonymous]

Ths will give you the whole number of people (Names) in Towns where the selected Names reside:

=count({<Name=, Town=P({<Name=P(Name)>})>} Name)

Regards,
Michael