topic Re: Problem with ALV Grid Control in Application Development and Automation Discussions

Problem with ALV Grid Control

Former Member — Mon, 08 Aug 2005 06:18:57 GMT

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

Re: Problem with ALV Grid Control

Former Member — Mon, 08 Aug 2005 06:57:47 GMT

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.

Re: Problem with ALV Grid Control

Former Member — Mon, 08 Aug 2005 08:12:36 GMT

Hi Jessie,

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

Re: Problem with ALV Grid Control

Former Member — Mon, 08 Aug 2005 08:29:37 GMT

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.