Sum Expression that exclude partial active selection.

[#1]

Hi Everybody

I create 2 gauge graph to display turnover of our business agent by quarter.

I generally select the year, the quarter and salesman. Now in the first graph I show the selected quarter, in the other I want to display the sum of all available quarter in the year for that salesman.

For example, let's consider 2009, now we are in the fourth quarter. If I select Q4 and John as agent, the first graph show the sum of this period for John, but the second gauge must show the sum of all quarter, indipendent of the active quarter selection.

My problem is the second gauge, How Can I obtained this sum without consider quarter?

This is the code I use, where N indicates "credit Note", to sum turnover

sum(If([Tipo Doc.]='N',Netto*-1,Netto*1))

I tried to put "1" before "If" but it excludes all selections and this is not what I need, I need to exclude only quarter selection.

Thanks

Rick

[#2 · Accepted solution]

Try this:

sum({<Quarter=>} If([Tipo Doc.]='N',Netto*-1,Netto*1))

[#3]

Perfect, it works.

thanks a lot