Sort based on FinancialYear and FinancialWeek

[#1]

Dear All,

I want to sort the chart by FinancialYear and Financial Week.

I have the dimension FinancialYear &'-'&Financial Week

I tried by using Dual function but I'm not getting it.

kindly find the attachment of Qvw.

i hope someone will help me.

thanks,

Mukram.

[#2 · Accepted solution]

Hello Mukram,

You can use Sorting as Expression : FinancialYear+FinancialWeek, that works for me.

PFA picture.

Please let me know if that was helpful or anything else is required.

Thanks,

itsangad