Duplicate codes but different group
Suppose i have this report:
Fields are Code, Amount, Year
1996 (A group per Year)
------
/Code/ /Amount/
AAAAA 100000
BBBBB 100000
1997
------
/Code/ /Amount/
AAAAA 200000
BBBBB 100000
1998
------
/Code/ /Amount/
AAAAA 300000 *
BBBBB 200000
CCCC 200000
2000
------
/Code/ /Amount/
AAAAA 500000
BBBBB 300000 *
CCCCC 300000 *
* - means that data should only display on the report
-When the amount reaches the value of greater than or equal to 300000 like in Code AAAAA in 1998 it will display that data on the report (I have a formula for that) but I dont want to display that data AAAAA on the next year even the amount is greater than the valuer of 300000. Other Codes also follows that step.
Hope you could help me through this.
e®@
|