Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry fabio that doesn't work for last year
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!!!
You want:
Sum ({<Boekjaar = {$(=max(Boekjaar)-1)}>}Amount)
That will give you the sum for the year before the max selected year.
all thnx for the excellent help !!!!