Creating a pivot table

- One of the usual ways…to display your data is in a table,…which is arranged into columns and rows.…Columns represent a single type of data,…such as order numbers or the state…an order came from,…and a row represents a specific order,…and contains a value for each column.…This type of table,…called a Straight Table in QlikView,…is useful for viewing your data.…If you want to rearrange your data dynamically,…though, you need to create a pivot table.…In this movie I will show you…how to create a pivot table…to view your data in a cross tabular format.…

My sample file is the create pivot report,…and you can find it in the chapter five folder…of your exercise files collection.…This report is connected to an outside data source,…and to create my pivot table…I open the Layout menu,…point to New Sheet Object,…and somewhat counter-intuitively,…open the Chart dialogue box.…On the General page of the Chart…dialogue box or Wizard,…click the pivot table icon.…

Doing so identifies that you want…to create a pivot table.…Go ahead and click Next,…