Need your expertise on mapping issue. I have a set of accounts which have made payment for the month of June. However once we mapped it, 2 type of result given (if the account do make payment in June). The query & the result given as attached.
Further, it looks as if you have used a table box. I would instead use a straight table or a pivot table. In this you should use as few dimensions as possible. My guess is that you should use [Account No] and REPDT as dimensions and Sum([Payment Amount]) and Only([Payment Date]) as expressions.
.png "Former Employee"){kind=icon}
