Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
You must create a graph / simple table and put the formula in the expression tab.