Skip to Content
0
Former Member
Jan 13, 2015 at 09:31 AM

Incorrect sort for Year/Period

420 Views

Hi,

In my OLAP report I am trying to sort year period field but it is giving wrong output.

Please check below snaps to understand it more.

I had made Year/Period filed Display as key and am trying to sort it in ascending order but unable to sort it. But at backend in BEx I am able to sort it in correct way.

I’m not sure we can create a variable, in OLAP, to strip some characters and get aresult with only MM.YYYY(001.2013).

Regards,

Mithun

Attachments

Error Snap.JPG (23.9 kB)