Zoom in Line Chart

[#1]

Hi,

I have a line chart showing a sum(Number) by date, with Full Total.

I'd like to be able to zoom on certains date but without filtering. I mean, let's say we have :

Data : 01/01/2009 : 5 - 02/01/2009 : 1 - 03/01/2009 : 10 - 04/01/2009 : 2 - 05/01/2009 : 3.

The Line chart will dump :

01/01/2009 : 5 - 02/01/2009 : 6 - 03/01/2009 : 16 - 04/01/2009 : 18 - 05/01/2009 : 21

I want to zoom on 04/01/2009 and 05/01/2009 and have the same values : 18 and 21.

If I simply select the date intervall it will show : 04/01/2009 : 2 - 05/01/2009 : 5.

Any idea ?

Thanks

[#2]

Hello,

See attached example. Sth like that?

Cheers

Karol

[#3]

Well yes, thanks.

I can't understand the aggr syntax but it works fine. I'll try to adapt that to my actual case.

Many thanks.

[#4]

If you can help me to adapt it with a second dimension, it would be great, I've add a dimention type to your example, wich have 2 value 'A' and 'B', the expression is cumulating both together....if you can help it would be nice. (attach modify qv)

Thanks