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!
Quote from: actcognosuser on 03 May 2010 11:45:56 AM
total(region for country).It does not seem to work.Gives a very large number.
try
total(distinct region for country)