<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/f74b2f4cd63a4157ab3f6b395e27bf8d&quot; frameborder=&quot;0&quot; width=&quot;3840&quot; height=&quot;2880&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>2880</height><width>3840</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>2880</thumbnail_height><thumbnail_width>3840</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/f74b2f4cd63a4157ab3f6b395e27bf8d-24794768c505117c.gif</thumbnail_url><duration>158.2301</duration><title>29 - Reports - Creating Excel Pivot Tables in AETL</title><description>In this video, I walk you through the process of recreating an Excel pivot table inside ADL using our sales data from a SQL setup. We start by creating a basic table and then move on to performing lookups. I demonstrate how to select the appropriate fields, manage the master data, and configure the table layout, including whether to display grand totals. By the end, you’ll see how to effectively set up your pivot table. Please follow along and try this out with your own data.</description></oembed>