Aggregation in ALV.

[Former Member]

Hi,

I want to sum the data in ALV only at sub level and not for all the rows.

My data goes like this

Amount Curr

500 EUR

200 EUR

150 EUR

200 USD

200 USD

250 USD

Now I want to sum the data based only on currency basis and not at total level.

My results should look like this

Amount Curr

500 EUR

200 EUR

150 EUR

850 EUR

200 USD

200 USD

250 USD

650 USD

In ALV when we do intermediate aggregation based on some column( like curr here ) we get total aggregation amount also at last( In our case it would be 1500 , I dont want to show the total aggregation thing as it would suggest a wrong sum, I want to show only the results at intermediate level.

Can someone suggest how it can be achieved. I've already implemented intermediate aggregation for my ALV, only thing left is to hide that last row which shows the total sum.

[Former Member]

Used subtotal feature of ALV