0 Replies Latest reply on Aug 15, 2013 4:47 AM by Amanda Blondeau

    How to calculate the running total for average commission by vendor?

    Amanda Blondeau

      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?

       

      Thank you in advance.