cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
calliandutra Frequent Visitor
Frequent Visitor

Get a field using MAX Function

Hi,

Just to example, i have a table with two fields:
- CustomerName
- Sales (Measure)

I wanna know and show only the name of the customer who did the biggest sale ( that means Max(Sales) )

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Get a field using MAX Function

I guess you can use TopN filter

 

Image 1 -> Shows all customer with their sales (no filter)

 

Capture2.PNG

 

 

Added another table and filter using TopN  to get top 1 customer with maximum sales

 

Capture.PNG

 

Here is the result after TopN filter:

 

Capture1.PNG

 

Hope it is helpful.

 

 





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




1 REPLY 1
Super User
Super User

Re: Get a field using MAX Function

I guess you can use TopN filter

 

Image 1 -> Shows all customer with their sales (no filter)

 

Capture2.PNG

 

 

Added another table and filter using TopN  to get top 1 customer with maximum sales

 

Capture.PNG

 

Here is the result after TopN filter:

 

Capture1.PNG

 

Hope it is helpful.

 

 





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.