Its the data gods that say, “Go Forth and Pivot”. The Nexus has 1,000 features on 1,000 different database platforms, and feature number 942 is pivoting. Business users and senior management love to see a pivot report, especially when it has sum totals, subtotals, and horizontal and vertical grand totals. So, that is why we make it so easy.
Query and get an answer set from any data source. Take a look at the picture below, but let me summarize by saying, “Left-click on PIVOT.”
When you click on the Pivot button, you will then see a new screen. Take a look at the picture below, but all you have to do is, “Left-click on OK.”
You will then see a new screen showing the columns from your answer set, which refer to as fields, and a series of box areas with the name of Filters, Columns, Rows, and Values. Left-click and drag any field(s) to the areas. I will start with the pivot columns I want on my report. I drag the field “REGION” to the COLUMNS area. I also drag the field “SALES_PERSON” to the COLUMNS area. Check out the picture below.
The final pivot report is complete. Check out the picture below. Here are the exact steps:
- I drag the field “REGION” to the COLUMNS area.
- I also drag the field “SALES_PERSON” to the COLUMNS area.
- I drag the field “PRODUCT” to the ROWS area.
- I drag the field “COST” to the VALUES area.
- I nominate myself for “Employee of the Year.“
The final report is displayed. Check out the picture below. I see my salespeople from the North Region and the South Region, and the sum of their sales for Boots, Jackets, Jeans, and T-Shirts. Their region groups the salespeople. I then see subtotals for both the North Region and the South Region. I now see two different sets of grand totals. On the bottom is the total which is the sum of all sales per salesperson. On the far right is the total for each product.
You can save the report in a wide variety of formats. Here is an example of saving the report to Excel.
To return to Nexus, press the minimize button or the X in the top right corner.
Thank you for reading about Nexus’ feature number 942 on pivoting. And please don’t hesitate to contact me for a free trial or demo of the Nexus product line.
CEO, Coffing Data Warehousing
Mobile: 513 300-0341
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 25 years. Tom has written over 75 books on all aspects of Teradata, Netezza, Yellowbrick, Snowflake, Redshift, Aurora, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus Product Line.