Display highest value in quarterly data

Question

My dataset has month and sales amount corresponding to the month. Like this - 

Jan $10
Feb $40
March $50

When I am trying to display the quarterly sale, it is showing the sum , i.e. $100. I want to display only the highest sale.

Answer 1

I guess your field name is in SUM. Just right click on your measure pill. Let's say it is SUM(Quarter).

Select "measure" from the drop down menu that appears after right click

Select MAX. That'll do for you.