Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi Kushalthakral,
Tried your solution. Unfortunately it is not working.
Hi Piyush
Please find the QVW is the same requirement you want i.e to sort months in filter
Thanks
Kushal
Hi Tresesco,
Thanks for quick reply. Once you select any value from that filter the sorting goes on toss.
Could you please check.
Thanks
Hi Tresesco,
Sorry did not understand your point
thanks
PFA