0

I have to pick the highest value from col 2 in relation col 1 using Tableau. The data is as follows

col 1       col 2
category 1   5
category 2   6
category 1   4
category 1   3
category 2   10
category 1   1
category 2   3

The desired solution is

col 1       col 2
category 1   5
category 2   10

I tried using the fixed aong with max function but in this case it outputs boolean value which I do not need. Could someone help me!

Thank you

Nithya
  • 33
  • 4

1 Answers1

2

Drag col 1 in the rows shelf.

Double click col 2.

Right-Click col 2 --> measure --> Maximum

(Eventually) Drag Max(col 2) from row shel to Text Mark

EDIT

See the screenshot as an example. [To be noted that you can achieve this simple result with differnt ways/clicks]

enter image description here

BTW: are you familiar with dimensions and measures? it seems to me that you may need some basics training/study in order to get familiar with Tableau basics.

You may start from here: https://www.tableau.com/en-gb/learn/training/20212

Fabio Fantoni
  • 3,077
  • 3
  • 22
  • 32