Skip to Content
avatar image
Former Member

how to Avoid Duplicate records in a report

Hi,

In my report I have got the following values for the same purchase order.

But, my requirement is,

1. Not to show the same duplicated Gross value not more than once.

2. Calculate the Devaiation using the total Gross - Total Invoice amount and that will give the correct figure for the actual difference.

Gross Invoice Deviation

94,000.00 12,690.00 81,310.00

94,000.00 25,380.00 68,620.00

94,000.00 24,322.50 69,677.50

94,000.00 11,750.00 82,250.00

94,000.00 11,750.00 82,250.00

94,000.00 6,345.00 87,655.00

Total 94,000.00 92,237.50 471,762.50

Please Advice on the above to get the proper reporting display like the below.

Gross Invoice Deviation

*94,000.00* 12,690.00 81,310.00

25,380.00 68,620.00

24,322.50 69,677.50

11,750.00 82,250.00

11,750.00 82,250.00

6,345.00 87,655.00

Total 94,000.00 92,237.50 1,762.50

Thanks for the help.

Regards

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 03, 2008 at 04:12 PM

    Hi Pramesh,

    You can hide repeated key values but I'm not sure you can do it for keyfigures, just check this link for Hide the repeated Key values.

    http://help.sap.com/saphelp_nw04s/helpdata/en/1e/99ea3bd7896f58e10000000a11402f/frameset.htm

    Hope this helps............

    Rgs,

    Ravikanth.I

    Add comment
    10|10000 characters needed characters exceeded