Forum Discussion

IanR's avatar
IanR
Icon for Helper III rankHelper III
9 years ago
Solved

Sort and filter by measure not displayed on table/chart

Hi,   I have created a measure based on RANKX which I want to use to sort and filter the entries in a table and a chart. So far this works when I have my ranking measure included in the visuals but...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Place the Rank Measure in the Visual Level Filter of the Visual and filter there!

     

    Alternatively you can use the built in TOPN functionality also in the Visual Level Filter.

IanR's avatar
IanR
Icon for Helper III rankHelper III
9 years ago

In this case I am - it's a CRM report showing contacts by country so I am showing the number of contacts ion each country and have sorted by that. I was thinking more generally - just in case this ever came up again. It's not a big deal. The tip about filtering by measures that are not displayed was the big one.

nithin9's avatar
nithin9
Icon for Advocate I rankAdvocate I
9 years ago

Hi All,

 

I actually have this requirement of sort by measure not displayed in the chart/table. For example, In the graph i want to display a calculated measure (premium) by states but sort the chart by YOY growth which is a calculated field. YOY growth should not be displayed in the chart.  Is there any way to to this? 

 

Thanks in advance. 

 

Nithin