{"id":665,"date":"2020-05-06T15:26:46","date_gmt":"2020-05-06T07:26:46","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=665"},"modified":"2020-05-06T17:38:19","modified_gmt":"2020-05-06T09:38:19","slug":"using-analysis-tables","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/using-analysis-tables\/","title":{"rendered":"Using analysis tables"},"content":{"rendered":"

Once you have imported a data set into Easy Excel Analysis<\/a> or SQL Data Analysis<\/a>, an analysis table is created.<\/p>\n

\"\"<\/p>\n

In this example, we’ve imported the global superstore 2016.xlsx<\/strong> file.\u00a0 What you can do now is to group the rows by one or more columns.\u00a0 To add a column to the group, click on the column header and drag it to the column headers<\/strong> area.<\/p>\n

\"\"<\/p>\n

Here, we have grouped our rows by Market<\/strong>, Category<\/strong>, and Sub-Category<\/strong>.<\/p>\n

\"\"<\/p>\n

At this point, you can easily analyze the sales data for each level of the grouped columns.\u00a0 You can add as many columns to the groups as you require, and you can also change the order of the grouped columns by arranging it in the appropriate order.<\/p>\n

We will now create summary values for each grouping level.\u00a0 To create a summary, right click on a column header in the table, and select the required summary.\u00a0 In our example, we will create a group summary based on the sum of the Sales<\/strong> column.<\/p>\n

\"\"<\/p>\n

Once created, the summary value is displayed on all of the grouping levels.<\/p>\n

\"\"<\/p>\n

You can add multiple group summaries by repeating the process above.\u00a0 Here, we have added another summary to display the total sales orders.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

To sort the groups by the summary values, you will need to select the summary item to sort by from the Customize<\/strong> menu.\u00a0 Here, we have chosen to sort by the Sales (sum) summary.<\/p>\n

\"\"<\/p>\n

All grouping levels will then be sorted by that summary value in ascending order.<\/p>\n

\"\"<\/p>\n

You can now quickly see which groups have the highest sales.\u00a0 You can sort the summary values in descending order by clicking on the grouped column.\u00a0 This symbol (highlighted in red below) indicates that the summary values are sorted in ascending order:<\/p>\n

\"\"<\/p>\n

and this symbol indicates the summary values are sorted in descending order.<\/p>\n

\"\"<\/p>\n

See also:<\/p>\n