This widget builds a pivot table from the source data.
Just setting its url gives a pivot table without any row / column definition.
The settings may be adjusted by passing url parameters, for example (with data similar to this example):
https://path/to/pivottable?rows=Party,Province&cols=Gender&aggregatorName=Average&rendererName=Col Heatmap