Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)
recategorized by

Any idea of how to measure filter measure names like when a value is selected, only that particular measure name appears like

When 'Finance' is selected,
Show Profit, Sales, Revenue

When 'Investment' is selected
Show Stock Price, # of shares

1 Answer

0 votes
by (22.5k points)
edited by

You can create three calculate fields:

1st Calculated field :

IF [Type of Dimension] = 'Finance' THEN [Profit] ELSE NULL END

2nd Calculated field:

IF [Type of Dimension] = 'Finance' THEN [Revenue] ELSE NULL END

3rd Calculated field:

IF [Type of Dimension] = 'Investment' THEN [No of Shares] ELSE NULL END

and drag all this into row shelf

If you want to learn more about Tableau, then go through this Tableau Training for more insights.

Related questions

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...