Show data for max month

[piyush_s11]

Hi,

I wanted to show data for max month.

In Data as of section I wanted to selected latest month & year.

Suppose I have data for April 2019 so that should show Data as Of: Apr 2019

Also for selection

I have a filter for the same. For this filter I wanted to sort the data from latest month & year to oldest month & year.

Thanks.

[kushalthakral]

Hi Piyush

You can use following expression in Sort tab of that filter 

Only({<[FileYear] = ,Month = ,[Data As Of] = >}FileDate)

and select descending 

I hope answer your question

Thanks

Kushal

[piyush_s11]

Hi Kushalthakral,

Tried your solution. Unfortunately it is not working.

[kushalthakral]

Hi Piyush

Please find the QVW is the same requirement you want i.e to sort months in filter

Thanks

Kushal

[tresesco]

Try sort by expression:
=Only({1}Date#([Data As Of], 'MMMYYYY'))

[piyush_s11]

Hi Tresesco,

Thanks for quick reply. Once you select any value from that filter the sorting goes on toss. 

Could you please check.

Thanks

[tresesco]

Try unchecking sort by State

[piyush_s11]

Hi Tresesco,

Sorry did not understand your point

thanks

[tresesco]

PFA