Custom sort in Pivot table

[#1]

Hello,

I have a pivot table which has a dimension called "Period name". Period Name is a calculated dimension and is composed of two fields Year & Period

=Year1 & chr(10)&Period.

I have a problem with the sort order. The Period has its own sort order and the year has its own sort order. How can I combine both the sort orders in the pivot table?

The period and Year are in different table.

Attached is an example.

Thanks a lot in advance!

[#2 · Accepted solution]

Use this in sorting expression of PeriodName in Pivot:

max({1}YearId)+max({1}PeriodId)

[jvishnuram]

Hi Warrior,

What is your expected output in this pivot.

[Gysbert_Wassenaar]

Try sorting by =only({1}YearId)*100+only({1}PeriodId)

[#5]

This expression worked just fine!

Thanks a million!

Regards,

On Jan 31, 2014 12:21 PM, "Mario De Stefano" <qcwebmaster@qlik.com>

[#6]

Hi Hero,

please mark it as correct answer!

Regards

MC