Help Needed with row count!

[actcognosuser]

Hi All,
         I have a summary row based on country.In the crosstab country and eligible regions are grouped.The summary row is at the region level.

If a country has more than one eligible region then I need to display the summary.or hide it.

I am thinking that row count would be an option.Then conditionally render it  .

I am not sure how to determine if a country has more than one region.I tried to do a rowcount by counting total(region for country).It does not seem to work.Gives a very large number.

Please advise guys!

[cschnu]

total(region for country).It does not seem to work.Gives a very large number.

try

Code Select Expand

total(distinct region for country)