How to sort the data in chronological order in the pivot table in Nprinting ?

[userpd_2021]

Hi Guys,

How to sort the data in chronological order in the pivot table in Nprinting ? I tried multiple solution from the forum.

But it doesn't seems to work for me , Below is the output I am getting. I want to asort it from Apr 2022 to Oct 2022.

[marcus_sommer]

It looked that your MonthYear isn't a numeric period-field else a string. This means you should create it properly within an auto-calendar or a master-calendar. See here for more background:

How to use - Master-Calendar and Date-Values - Qlik Community - 1495741

- Marcus