I'm having a problem using the CountDisinct aggregate in a group by expression in the RadGrid. I'm using the aggregate function to get a unique count total in my Group header. I can reproduce this issue in the online demo as follows:
If i take the default grouping expression 'Country [My Country], count(Country) Items [My Items], Sum(TotalAmount) GroupTotal [Group Total ] Group By Country'
and i change 'count(Country)' to 'CountDistinct(Country)' suddenly the total for My Items becomes blank. The final grouping expression looks like this Country [My Country], CountDistinct(Country) Items [My Items], Sum(TotalAmount) GroupTotal [Group Total ] Group By Country.
What am i doing wrong? Is there another way to get a count of unique items in the group header?
Thanks
Marcel
If i take the default grouping expression 'Country [My Country], count(Country) Items [My Items], Sum(TotalAmount) GroupTotal [Group Total ] Group By Country'
and i change 'count(Country)' to 'CountDistinct(Country)' suddenly the total for My Items becomes blank. The final grouping expression looks like this Country [My Country], CountDistinct(Country) Items [My Items], Sum(TotalAmount) GroupTotal [Group Total ] Group By Country.
What am i doing wrong? Is there another way to get a count of unique items in the group header?
Thanks
Marcel