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!
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