Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Could some one help me on this. We have a requirement to show last 12 months of Price Data and I can able to get last 12 months of data by using following Expression
sum({1<[Fiscal Date]={'>=$(=MonthStart(Max([Fiscal Date]),-12))<=$(=MonthEnd(Max([Fiscal Date])))'}>}Price)
and Dimension as Month. Following output is generating
But when ever we select any particular month we can able to see last 12 months data but it's not in an sorted order. We are getting following result
We need it see in an order. If we select Nov-2019 then it should follow a sequence like Nov-2019, Oct-2019, Sep-2019..... Dec-2018, Nov-2018.
Could some one can please help to create sample qvf to resolve this issue. you can find sample data in attachments
Thanks and Regards,
Satya
Check the graph's sorting tab in edit mode, you should have date in the first position and ordered.
Hi Saryk,
Thank you so much for responding on the post.
I am using Max(Date) in Graph Sort option and it's working fine until we doesn't made any selections but when we making any selections then sorting order is missing. It not displaying an sorted order
Thanks and Regards,
Satya