I grouped my data by month and what I want to do is that I want to set the data to 0 if it is not the last record in the group like shown below, what can I do? Or can report do that?
Jan
Mr. A $10000 <--- want to become 0
Mr. B $20000
Sum1= 30000
Feb
Mr. A $2000 <--- want to become 0
Mr. B $3000 <--- want to become 0
Mr. C $4000
Sum2= 9000
----------------------------
Power Wong
Every problem will have a solution, the only problem is that can you find it out.