How to create a SQL dataset with a group on a computed column

ihabo01

Hello all,
It has been a while that I have been trying to find an answer but I had no luck.

I have an SQL query based dataset, and I want to group based on a computed column.
Is there a way to do that?

Your help is much appreciated.

mwilliams

Hi ihabo01,

You should be able to group on this field in your table or list.