>Very quick one....there are several ways....one way (probably not the best for performance, but...)
>
>SUM ( case when Category = 'Capacity' then Total_Cost else 0 end) as Whatever
>
>
>
>Again, not great for performance, but I believe it should work.
>
>Alternatively, if that doesn't work, you could do a subquery with the total just for that category, and then join to the subcategory results.
>
>But let me know if that works...

It is actually good for performance and most recommended way.

Nice to see you back!