|
|||
Use this practical tool to categorize records in a database, based on a category table. |
|||
Follow the following steps: |
|||
4. The table below shows how the result will be displayed. | |||
Besides, You can use the added field to create a pivot table. |
|||
In order to obtain the pivot table you must activate the corresponding check to the option: "add pivot | |||
table", Then you have to indicate the fields you want to analyze together with the kind of format you | |||
want to visualize for the pivot table. | |||
An example is shown on the images | |||
1. Check on "Add pivot table" | |||
2. Indicate the fields to analyzer and the kind of formats you want to visualize | |||
3.Press the button "Do it" | |||
Note: Optionally you can press the button "View pivot table" to change your preferences concerning to the creation of the pivot table. | |||
This is the result | |||