As the title suggests, I'm trying to show the occurrence count as an x axis. The intent (screenshot below) is that each product would have a common baseline and I would display the sales for each agent of that occurrence.
or example, John's Sales for Occurrence 1 should be 105, 75 for occ. 4 and 25 for occ. 7
I know the outcome will likely involve a Running Total on Number of Records but I can't even get that to work right.
Help would be much appreciated.