Hide Field in Matrix

[bgarland]

Hi all. I had to add in the field for fiscal period (month) number in order to get my fiscal months to sort properly. But how do I hide that number field? It's not needed for display, just sorting. 

[Anonymous · Accepted solution]

Hi @bgarland

To sort the month name, you dont have to include the number in the visual. Assuming your month name and number both objects from same table.

From the field tab, click on Month Name, go to Modelling-> Sort by -> Select Month No.

You visual will be sorted accordingly.

Thanks

Raj

[bgarland]

Thanks. That may not work in the long term as other visuals may require different sorting, but that soves my problem for now.