The chart I'm trying to create is a tree map. It shows up to 6 months of data (depending on choices on quick filter) with size based on Commission. The calculation used for commission: RUNNING_SUM(AVG([Commission]))
The issue is it doesn't seem to be a cumulative calculation, instead a running average. What I'm trying to accomplish is the average commission per vendor by month, then adding cumulatively.
I test by limiting the data just to January, but when I also add February the number may drop instead of increase. What am I doing wrong?