How to get total count of IDs based on selection of region

[#1]

Hi,

I have one staright table with column Unique ID, Region. my user wants to see the toatl count of IDs based on selection of Region. I tried using Total Count in Statistics box but it is showing N/A.  Could anyone help me how to do this.

Thanks.

[matthieu_burel]

Perhaps this can help you :

= Count({1<REGION = p({$} REGION)>} ID)

This formula will only take in consideration the ID of regions selected and not the other selections.

[#3]

Thanks for this. Could you tell me where can I use this because my user wants to see the count separately. and I can able to see the Total Count for remaining columns but not able to see only ID column in Statistics box. and this ID is having Primary Key.

Amelia.

[matthieu_burel]

You must create a graph / simple table and put the formula in the expression tab.