topic ALV in Application Development and Automation Discussions

ALV

Former Member — Tue, 01 Apr 2008 16:23:42 GMT

Hi All,

I developed an ALV report.Now i want to export the list to excel file.

Here i got two options 1.Table

2.Pivot table

what is this pivot table option.Can you give me some explanation regarding this option...

Thanks,

Ravee

Re: ALV

Former Member — Tue, 01 Apr 2008 16:29:30 GMT

A pivot table is a data summarization tool found in data visualization programs such as spreadsheets (e.g. Excel sheet). Among other functions, it can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. Pivot tables are useful to create crosstabs quickly. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

Hope this helps.

Gary.

Re: ALV

Former Member — Tue, 01 Apr 2008 16:38:48 GMT

Hi,

chk this

Pivot table is a tool of MS-Excel to obtnain a navigation in data contained in a sheet of a file of MS-Excel. You can achieve this tool via menu of XLS.

It is similar to a drill down in BEx queries.

This is a functionality of Excel.Users usually like to run the query in BEx and then copy over the data into the excel pivot tables to do their own calculations/manipulations etc.

A pivot table is generating reports using Microsoft Excel alone.It has a drag and drop interface that is easy to use.It works by looking for values in the columns and grouping them , if the values are merged , pivot table cannot be used.Persons who are very comfortable with excel would like to take the query results and do their own calculations and use pivots to do the analysis.

Re: ALV

Former Member — Tue, 01 Apr 2008 18:13:01 GMT

Thanks for your answer