Hi Analytics Brain Trust!
I may be overthinking this, but haven't gotten it to work yet.
Is there a way to get a running sum of tickets sold as of past order dates in a pivot table? I'm envisioning day in order date as rows and the cumulative number of tickets sold as of that day as a column. I don't need to get a snapshot without later changes, returns, etc. But I do want each date to exclude sales from later order dates. I know this is usually RSUM line chart territory, but I need the numbers in this instance.
Thanks in advance for any help!
It should work as a pivot. That's the way I used to do it in Excel before analytics. It reads a bit better as a cumulative weekly, and/or zero sales days will be missing from your table.
Thanks Heath! Missing 0 days would be fine. Which function would you use in Analytics? RSUM([Ticket Paid Count]) is giving me an "unknown error" in a pivot table.
Is this what you are looking for? Can send functions if so
Hi Kanani, yep, this looks like exactly what I'm looking for!
Here's the formula for running total: RSUM([Total Ticket Paid Amount])
And for weekly variance: sum([Ticket Original Paid Amount])
And a screen shot of filters
Ahh, I had RSUM([Ticket Paid Count]) instead of Total Ticket Paid Count. It's all in the details. Thank you!!
Commenting again here to see if anyone has had an accurate running sum since onsale work while also limiting the rows to only show the last 7 days?
I got some help in this thread on creating one that shows 30 days. I assume would be applicable for a 7 day chart. community.tessituranetwork.com/.../81873