...
First of all, switch to the Pivot table view.
...
The main functionality of Pivot table view are Fields, Options, Format, Charts and Export.
How to add the field to your Pivot table?
...
By default, Pivot table fields that are placed in the Values area will be displayed as a SUM by default.
You can change the default calculation by clicking the summa sign. Then select the necessary option.
...
3. When you have set all the necessary configurationconfigurations, click the Apply button.
...
4. You can display any generated report on the Chart view.
You can choose one of two types of data visualization on the chart.
...
...
Stacked column:
...
Clustered stacked column:
...
5. Choose the necessary Layout options (Grand totals, Subtotals, Layout).
...
6. Conditional formatting: you can apply it to the entire table and to the particular Value. This option provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show inequality based on the provided criteria.
In the first raw row, choose the calculated value, option for condition (less than, greater thenthan, equal to, etc.) and enter the number.
...
In the second row, you can set the font and font size, text color, or highlight the cell. That will work if the condition in the first raw is true.
...
8. The Filter function allows you to filter a range of data based on the your criteria you define. To do it, click gear near them and check the necessary options.
...