Next in the editor, configure the pivot table parameters:
Posted: Wed Jan 22, 2025 4:09 am
In the "Rows" section, specify the column with traffic channels;
In the "Values" column, specify the column with data on the number of leads or profit received.
The system will collect information on these two parameters in a table and you will be able to quickly see which channel brought in more income. You can also add additional filters, for example, not to take into account information on channels that brought in less than 10 leads.
Google Sheets: A Complete Guide to Using the Tool
Read also:
Why Professionals Shouldn't Be france telegram number database Afraid of AI Taking Their Jobs
Formulas (functions)
Functions are formulas that help you quickly perform the necessary calculations. In Google Sheets, you can use mathematical, text, logical, financial, statistical and other types of functions. A full list of them is available in Google Help .
The function bar is located under the toolbar. It contains formulas for calculations.
Google Sheets: A Complete Guide to Using the Tool
To add a formula, click Insert → Function and select the desired option from the catalog.
As an example, let's take a simple formula for summation.
Google Sheets: A Complete Guide to Using the Tool
In the "Values" column, specify the column with data on the number of leads or profit received.
The system will collect information on these two parameters in a table and you will be able to quickly see which channel brought in more income. You can also add additional filters, for example, not to take into account information on channels that brought in less than 10 leads.
Google Sheets: A Complete Guide to Using the Tool
Read also:
Why Professionals Shouldn't Be france telegram number database Afraid of AI Taking Their Jobs
Formulas (functions)
Functions are formulas that help you quickly perform the necessary calculations. In Google Sheets, you can use mathematical, text, logical, financial, statistical and other types of functions. A full list of them is available in Google Help .
The function bar is located under the toolbar. It contains formulas for calculations.
Google Sheets: A Complete Guide to Using the Tool
To add a formula, click Insert → Function and select the desired option from the catalog.
As an example, let's take a simple formula for summation.
Google Sheets: A Complete Guide to Using the Tool