Using DISTINCT and SUM together

[#1]

Hi All,

   I am a newbie here. I am facing issue, please suggest.

I have data like below, the data is not normalized so need to write some expressions.

I have Project data, quarter wise. As below figure states, I have repeated data for the same quarter.

I am trying to put expression is the chart, where the Approved budget will be the sum of the column where the quarters are distinct.

Please help as I am really struggling with the syntax.

[swuehl]

Try with a bar chart, a chart with dimension Year-Month and two expressions for Approved / Exenditure should show the data quite well.

Or what is the way you expect the data to look?