Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I have a calculated dimension that is pivoted up
It is
if([WF Period End Date]>[SA Year End Date],Year([WF Period End Date]),[WF Period Name]))
There my calculated dimension because it is pivoted upwards shows values in this order
2015 2016 Mar-15,Apr-15....
How do I sort it so that I get the following order
Mar-15 April-15...............Dec-15 2016 2017 2018
What is the most efficient way?
Thanks
Hi,
Create inline table in your data model with sort no for each date and use that column for sorting where ever you need