showing the actual value of a field

[gembreda]

Dear QV-user,

I am in need of help to solve a problem in one of my QV-charts.

In my chart I would like to show the date below.

10-10-2011          Dave     London Office     Finance department     10

10-01-2011          Jane     London Office     IT department              12

10-01-2012          Dave     Paris Office        Sales department        20     <= Current Value Paris Office, Sales department

and I would like to see this:

Name	Office	Department	Date	Value
Dave	Paris Office	Sales department	10-10-2011	10
			10-01-2012	20
Jane	London Office	IT department	10-01-2011	12
Total				42

The formula I was thinking of was

=Only({$<Jaar = {'$(=YEAR(Today()'}>} Afdeling.Niveau2)

This does not seem to work.

Anyone got a solution?