video1.0<iframe src="https://www.loom.com/embed/413f8a5792794c00a781fe1646f71547" frameborder="0" width="1728" height="1296" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>12961728Loomhttps://www.loom.com12961728https://cdn.loom.com/sessions/thumbnails/413f8a5792794c00a781fe1646f71547-85adc259934ce78f.gif57.9867In this video, I walk through the process of creating a pivot table using our data, focusing on aggregates and grouped columns. We’ll see how to export the results, which include the sum of totals and counts for each product category, specifically the Gadget category. I also demonstrate how to convert one of these values into a custom expression. Please pay attention to the steps as they will be crucial for our upcoming analysis. Let me know if you have any questions or need further clarification!