This is issue being faced by business , where one key figure ( PF% ) is creating a problem i.e. If I remove/hide key figure in query the result is showing correct value, but If i add Key Figure the value results two lines .. one line showing the latest data and another shows old data.
User reported that in one query shows 2 sales order lines. The first line refers the old data has zeros.
P.S: Query has zero suppression active = 0.