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 7, 2018 in Tableau by GandalfDwhite
• 1,320 points
169 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 7, 2018 by QueenBee
• 1,820 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
283 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 15, 2018 in Tableau by AwesomeSauce
• 860 points
683 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 13, 2018 in Tableau by xyz
• 1,560 points
5,304 views
0 votes
1 answer

Issues with the Range value in Tableau

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

answered May 9, 2018 in Tableau by Atul
• 5,550 points
616 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,230 points
7,519 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,230 points
682 views
+2 votes
1 answer
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
2,898 views
0 votes
1 answer

Hover text shows numbers in decimal points

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

answered Apr 3, 2018 in Tableau by QueenBee
• 1,820 points
225 views