Sorting Issue

[#1]

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

[chiru_thota]

Hi,

Create inline table in your data model with sort no for each date and use that column for sorting where ever you need