I have an Oracle Classic Analysis that I need to suppress the duplicates in a measure. In the example below, you can see where the amount is on two separate lines for project id 345336508. The total amount should be 17132.50 which is correct, but not twice. Can anyone suggest a work-around for this? I have tried using the built-in Suppress feature but it doesn't work on a measure. Any suggestions appreciated. Thank you!
