Pivot widgets have been updated so that parent locations can be added as extra data columns. For example, if you build a widget for Brazil Municipios (L4), previously, only the Municipio location would be visible as the Location column.
Now, you can click “No Pivot”, and there is a new select box where you can optionally select ancestor locations (L1 (Country), L2, and/or L3) or any combination of those so you can tell which country, province, district, any particular location belongs to. Once selected, they are also available to be pivoted on.