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.