Sum from This Year and Last year in Straight table

[francisvandergr]

Hello,

I have a question. Can someone help me. On this forum i seer only cases with a sum t/m a period. What i want is a sum in a column what presents the sum of all records from the selected year. And in another column i want a sum of the records from the selected year -1.

I have included a qvw file. I hope someone knows this, because i can use this formule in future often.

The result has to be: (when i select 2010)

2010 2009

Reknr 7000 3000 1150

Reknr 8000 50 200

[#2 · Accepted solution]

maybe Sum( {$} Amount)

[francisvandergr]

Sorry fabio that doesn't work for last year

[#4]

In your chart.....you need create two expressions......

1st take a select year or higher

=SUM({$<YEAR={$(=MAX(YEAR))}>} Amount)

2nd Selected year -1 or second higher

=SUM({$<YEAR={$(=MAX(YEAR)-1)}>} Amount)

Try this, if you have some doubt ask me!!!

[#5]

...

[#6]

You want:

Sum ({<Boekjaar = {$(=max(Boekjaar)-1)}>}Amount)

That will give you the sum for the year before the max selected year.

[francisvandergr]

all thnx for the excellent help !!!!