Thanks @Luiggi for the response. Without seeing the results you got with your example I'm not sure what you mean by correct values. To clarify, the values I see are "correct", but only if you're looking at the first row in the raw data set (1 row per project, and then split out by date - each project is updated daily). To clarify some things about my query, I'm querying from a table and joining 3 additional tables, I'm using sum for the values I want to see, but the stacked bar chart is showing the cumulative sum for each column and then showing that as a percentage in the stacked bar when you look at the y axis, but the tool tip is only showing the first project in the data set. I'm guessing the example you're using is less complex, based on how you described it.