...
Create a Stored Procedure Task in Studio and select the Function at_wkf_geopivot_sum.
Here is a snapshot of the street crime data that we are using:
Now select each parameter in turn to enter the values in the Edit parameter area e.g. for the Street Crime against Ward we will use the crime_type as the category to sum.
If successful, the following is returned:
at_sys_geopivot_sum finished: table [output_table] created
Once the table has been created this can be added as a Layer in Studio e.g.
Now a Thematic can be applied and here we have selected to show how drugs crime is split across the Wards e.g.
Stored Procedure at_wkf_geopivot_count
...