Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table:
State | County | Branch localtion |
---|---|---|
Oaxaca | Juchitan | Juchitan 1 |
Oaxaca | Juchitan | Juchitan B |
Chiapas | Tuxtla | Tuxtal 1 |
Mexico | Ecatepec | Ecatepec 1 |
Mexico | Ecatepec | Mercado |
Mexico | Ecatepec | Autopista |
How can I count in a KPI all the counties where I have coverage (3) instead of a =count (County) will show 6?
May be add DISTINCT...
Count(DISTINCT County)
In any text box Object write
=Count(Distinct County)