Last row as total

[Anonymous]

Hi,

how can i display the last row in a straight table as total?

Example:

Date	50
11-01-2015	4
11-02-2015	10
11-03-2015	90
11-04-2015	2
11-05-2015	50

Greetings

Phil

[Mark_Little]

Hi,

Within the chart properties > Presentation you have the totals section.

Mark

[Anonymous]

Hi Mark,

thx for your reply. But thats not what i want.

The Row for Totals should be on the first Row. But the value that is displayed there, should be the value of the last row in the table. Like in my example.

[miguelbraga]

Find this attached file:

[Anonymous]

Hi Braga,

It shows 156 as total in your Example. But instead it should show 50, because thats the "newest" value in respect of date....

[miguelbraga]

This?

[miguelbraga]

See my answer above . It is the solution for your problem in a simple and clean way

[sunny_talwar]

May be try this expression (using Braga's complied QVW file)

=FirstSortedValue(Aggr(Sum("50"), Date), -Date)

[Anonymous]

Sorry, this isnt working for me because i cant calculate these fields in script.

There is an expression for this column. If you select 11-01-2015 to 11-13-2015 then it should show the value of 11-13-2015 als total. If you select 05-01-2015 to 05-24-2015 then it should show the value of 05-24-2015 as total.

[sunny_talwar]

Have you looked at the FirstSortedValue solution provided below?