Display highest value in quarterly data

0 votes

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.

Apr 6, 2018 in Tableau by GandalfDwhite
• 1,320 points
12 views

1 answer to this question.

0 votes
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.
answered Apr 6, 2018 by QueenBee
• 1,810 points

Related Questions In Tableau

0 votes
2 answers

How can I display filtered value and grand total in the same sheet?

You can create a fixed calculated field ...READ MORE

answered Sep 15, 2018 in Tableau by Machdata
• 340 points
71 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
38 views
0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,550 points
1,438 views
0 votes
1 answer

Issues with the Range value in Tableau

One of the best solution is to ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
42 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,361 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
50 views
+2 votes
1 answer
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
417 views
0 votes
1 answer

Hover text shows numbers in decimal points

Do this: 1. Right click on the calculated ...READ MORE

answered Apr 2, 2018 in Tableau by QueenBee
• 1,810 points
24 views