• Hi GrassHopper,

    Try this one for third scenario. I believe this will work for you..

    case when (sum(total) over (partition by name1) >100) AND (MIN(total) over (partition by name1) < 25) AND MIN(total) over (partition by name1) = TOTAL Then 1 else 0 end as ForCase3