Max Month's Amount to be expression total in pivot table:QlikView

[suhasarchak]

Hi,

I am trying to get the total of expression in a pivot table in QlikView based on the Month which is the dimension. Following is the example table:

Month	Amount
Apr-16	456
May-16	5325
Jun-16	535
Total	535

Please help me how this can be achieved

Thanks,

Suhas Archak

[Anil_Babu_Samineni]

Sum({<Month = {=max(Month)}>} Amount)

Is Month looking Month(Date) & '-' & Left(Year(Date),2) as Month

[sunny_talwar]

May be like this:

Max(Aggr(Sum(Amount), Month))

[rupamjyotidas]

No Sure I understand your question, but I believe you can group the sum by month

Sum(Total <Month> Amount)

[suhasarchak]

Hi,

Thanks for your replies. I tried all options but could not get the desired result. The expectation is to get the latest month's sum amount in the totals. In my example, I need to display 535 in totals as the sum of amount being for June which is the latest month.

Thanks

[sunny_talwar]

How about this?

=FirstSortedValue(Aggr(Sum(Amount), MonthYear), -MonthYear)

[#7]

maybe this?