Why is sum measure is not working in derived sql? But works when custom filter is applied

Looker Q&A Looker
1

On using this .lkml file, sum is not calculated for my column “SumPlannedQuantity”

Complete file can be viewed here : https://textsaver.flap.tv/lists/45ox