last value in sub sum

[#1]

Hi all,

i have a table with the stock values per month e.g.

month	stock value
1	100
2	120
3	150
4	160
5	170
6	100
7	90
8	120
9	130
10	140
11	120
12	90
total	1490

The problem is that the total amount will aggregate all the stock values of the year.

Is it possible to show only the last value in the total amount (90)?

Thanks in Advance

Best regards

Daniel

[Nicole-Smith]

This is about as close as I'm able to get it.  QV won't allow me to put partial sums on any of the other dimensions (I think because of the aggr() that I'm using).  Hopefully this is a step in the right direction!

[Nicole-Smith]

Your other option would be to calculate these totals in the load script.

[kiranmanoharrode]

Dear Daniel

          Simply Create a variable vMaxMonth = Max(Month) in variable Overview

then use below expression in text box

=Max({<Month={"$(vMaxMonth)"}>}Amount)

Regards,

Kiran Rode

+91 8976977897