Problem with ALV Grid Control

[Former Member]

We are using an ALV Grid display and downloading the output to a Spread Sheet. When we are downloading the output to Pivot table it is showing the sums of all numeric fields with

column name starts with 'Sum of <Field Name>'. But we need only sum of few columns. Is it possible? If so, how?

Also we need the sort sequence of our Grid Display to be considered while downloading to pivot table. Is it possible?

Let us know if any one worked with such scenarios

[Former Member]

Hi,

I have also worked on the same, just immediately after downloading it will show total line for each column so u will see a number of total lines.

To overcome the same,

Double click on each of the column, a <b>"Pivot Table field Window"</b> will open in that we need to choose the radiobutton <b>"none"</b> , initially "Automatic" radiobutton will be selected . Because of that only we are getting the total lines. Actually it is totalling column vice, so for each column an extra line was added.

Hope thsi helps.

[Former Member]

Hi Jessie,

Is there anything that can be done from SAP side, to avoid this?

[Former Member]

Hi,

Not from SAP side because this we are downloading to the XL, so if u r not using 2003 then u wont get any data too.