How to make sorting column invisible in matrix table but keep sorting?

[nicole11ir]

Hi

I have a matrix table with Fisical Month ID as a column in my table and I need no keep sorting based on that. However I would like to make it invisible from my table. Any advice would be appreciated.

[Anonymous · Accepted solution]

@nicole11ir  -

Go to the Model View, and set the Sort by column of the Fiscal Month to the FiscalMonthID.

Then you can sort by the month.

Cheers!

Nathan