Then, select the datasource to query data. When the datasource is selected, the full configuration menu is available.
You need to select at least one dimension in the Rows selector, one dimension in the Columns selector and one metric in the Measures selector. Here is an example where Country is used as a rows dimension, Category is used as a columns dimension and $$count$$ is used as the measure:
Warning: for a pivot table, the "limit" field is the limit of cells of the table. The default is 1000. If you select many dimensions, keep in mind to increase this limit (using the limit field below in the configuration).
Note that if you have several measures in your configuration, you will get several total columns on the right of your table: