Reply
Regular Visitor
Posts: 19
Registered: ‎01-21-2017
Accepted Solution

Hide Field in Matrix

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. 

 

2018-08-01_132123.jpg


Accepted Solutions
Super User
Posts: 684
Registered: ‎11-01-2017

Re: Hide Field in Matrix

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

View solution in original post


All Replies
Super User
Posts: 684
Registered: ‎11-01-2017

Re: Hide Field in Matrix

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

Highlighted
Regular Visitor
Posts: 19
Registered: ‎01-21-2017

Re: Hide Field in Matrix

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