{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/042be3be13004355b0dedec1be67b400\" frameborder=\"0\" width=\"2244\" height=\"1683\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1683,"width":2244,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1683,"thumbnail_width":2244,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/042be3be13004355b0dedec1be67b400-00001.gif","duration":287.6666666666668,"title":"Creating a Running Total with a Query Column 🏃‍♂️","description":"Hey there! I just had an idea that using a query column, we can easily create a running total. I know it's something that people ask about from time to time, and there are a few different ways of doing it, but none of them are straightforward. So, I thought of giving it a try. In this video, I'll show you how to create a running total for monthly revenue using a query column. I'll add a row ID column, a lookup column, and a row index column. Then, I'll create a query column and a roll-up column to get the running total. I'll also explain how to fix any errors that may occur. By the end of this video, you'll be able to create a running total with just two columns. Let's get started!"}