Comparing row columns to identify max and min across the entire dataset

Hi Kevin,

In your case, we can using RunningValue() function to work around this issue.

You can refer to the expression below:

=RunningValue(Fields!Total.value, Min,"DataSet1")

=RunningValue(Fields!Total.value, Max,"DataSet1")

There is an article about RunningValue() function, you can refer to it.

http://technet.microsoft.com/en-us/library/ms159136(v=sql.100).aspx

Hope this help. If there are any misunderstanding, please feel free to let me know.

Regards,

Alisa Tang