Reports Help

Pivot Table

Watch How to Create Pivot Table in SkyDesk Reports Video

Pivot Table allows you to dynamically rearrange, group and summarize data for easy analysis of large sets of data. You can transform data in a table(s) into interactive and meaningful summaries easily by using intuitive drag and drop interface provided by SkyDesk Reports. You can also filter, sort and customize the appearance and content of your Pivot Table the way you want it, by using wide range of options provided by SkyDesk Reports. For users who view/access the pivot tables, SkyDesk Reports offers a range of interactivity options like Data Drill Down, User Filters, Sorting, Export etc.,

Following screen-shot displays the basic layout of a Pivot Table in Design Mode.

  1. Columns from the source table that you assign to a row orientation in a Pivot Table.
  2. Values of the column from the source table that you assign to a column orientation in a Pivot Table.
  3. Column from the source table that contains values to be summarized.
  4. Column/Rows in the Pivot Table that contains grand summary information.

Following screen-shot displays the basic layout of a Pivot Table in View Mode.

In this chapter we will discuss about the following:

Top