in order to understand what might cause such a problem, I'd like to see the data load script. Even better, if you could create a "scrambled" data example and post it along with your app, it would be even easier to troubleshoot.
You certainly don't want to use DISTINCT within a Sum() because some of the amounts are legitimately repeated, and you don't want to lose them.
Upgrade your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense
correct me if i'm wrong, but by the looks of it, the approved budget column is the total for the six months?
If this is the case, then I would split it up into two tables,
- budget item.(Key)
- approved budget.
- budget item(Key)
- project date
- project amount