how to count not null in dimension

[Anonymous]

Hi Experts,

I have one field called Location.

In this field have null vaules like below....

Location:

IND

PAk

Aust

Chin

[]

[]

when i try to put count(Location) in pivot table expression + it comming count is 5 .we want count is 3.

How to do that except how to count null vaules pivot table expression level

[Chanty4u]

chk here

checking null in set analysis