Advanced Sort

Venu Gopal K shared this question 1 year ago
Answered

Hi,

Is there any way that we can do sorting based on 3 measures.

I have measures say, M1,M2 and M3. Now i want to sort the data based on M1 followed by M2 and followed by M3.

Is there any way that we can achieve in Yellowfin? Bcz, in report we can either sort only using one measure, if i do on second measure then sorting on the first measure will be excluding.

Thanks,

Venu

Comments (3)

photo
1

Hi Venu,

Thank you for reaching out.

This can be accomplished by clicking on Report Formatting > Table Sort > Column 1 -- Change drop down menu selection from None to [M1].

Choose your Sort Order, then do the same for Column's 2 and 3:

29754a2927afb0368a2abb5d509a4f2a

Let me know if this makes sense.

Regards,

Mike

photo
1

Thanks MIke. This what I am looking for!


Regards,

Venu

photo
1

Hi Venu,

Glad I can help! I'll go ahead and mark this as answered, but please don't hesitate to reach out with any further questions or issues.

Regards,

Mike

photo