support

Computational Column after Grouping

Given a food sales table in which the data is grouped by the food type, calculate the sales amount of each food, subtotal sales amount of each type of food, and the total sales amount of all foods.
business spreadsheet software-esCalc VS Excel
Calculate the sales amount of each food. In Traditional Business Spreadsheet Software, there are two common methods:

1. Method 1:

business spreadsheet software-Excel VS esCalc
2. Method 2:

business spreadsheet software-Excel VS esCalc
Calculate the subtotal sales amount of each type of food and the total sales amount of all foods:

In Traditional Business Spreadsheet Software, When calculating the total sales amount in each category, you will still have to fill in respectively:
business spreadsheet software-Excel VS esCalc
In Traditional Business Spreadsheet Tool, the expression can be generated automatically on the subtotal and total rows when performing the categorizing and summarizing operations. However, it is rather inconvenient if it is grouped first and then filled in the formula, or you will have to calculate several statistic values in the subtotal or total rows when categorizing and summarizing.

In Traditional Business Spreadsheet Tool, to categorize and summarize after grouping, it is much convenient for users to use SUBTOTAL function than SUM function. However, you will still have to fill in or copy and paste the expression manually. When the volume of data grows high, in particular the number of groups, then the data processing will become cumbersome and error-prone. In addition, when using the categorization and summarization functions in Traditional Spreadsheet Tool, the requirements on the format of table are rather strict.

import data to desktop BI tool

Calculate the sales amount of each food:
calculate with desktop BI software-esCalc

Calculate the subtotal sales amount of each type of food and the total sales amount of all foods:

Calculate the subtotal sales amount of any type of food. For example, fill in the expression ={F4}.sum() in F3, and the subtotal sales amount of all types of foods will be calculated automatically. Then, in F2, fill in the expression ={F4}.sum() or ={F3}.sum() to calculate the total sales amount of all foods. In esCalc, the set of homocells will be analyzed automatically according to its respective position. The result is as shown below:

desktop BI software-homocells calculation

In esCalc, by inventing the innovative concept of homorows, the data of the same business background will be placed in the homorows in the spreadsheet. In this way, you only need to fill the expression in one cell, then all of its homocells will be auto assigned with this expression, and auto migrated according to the position. The statistics data of the same business will be calculated all at a time, which is concise and efficient.