Sorting Issue

Fri, 03 Apr 2015 21:05:31 GMT

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

Re: Sorting Issue

chiru_thota — Fri, 03 Apr 2015 21:18:49 GMT

Hi,

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