how to pick up the last number in each month to plot in line graph qlikview

[Anonymous]

I have the following data in excel.  the second column is accumulated so I only need to pick up the last transaction for each month to plot it on a month to month line graph.  Any ideas how I can do this?

so far I've tried

=count({<TwitMonth=, %TwitDate={'$(=Date(Max(%TwitDate)))'}>}TwitCount)

Any assistance appreciated.

LC

[Kushal_Chawda · Accepted solution]

try

=FirstSortedValue (DISTINCT TwitCount, - %TwitDate)

[Anonymous]

thank-you. Even though the formula errors it still works.  Weird

[Kushal_Chawda]

Yeah, It looks like there is error but still works. This is the beauty of QlikView