Filtering multiple combinations of two fields in single worksheet

0 votes
How to filter multiple combinations of two fields in single worksheet? I have id from my data source as 10 digit no - M/A/E/N - store-id.
store id also exist as a separate field along with id . I want to filter using store id and sort according to M/A/E/N orders of those stores must only be shown.
Apr 10, 2019 in Tableau by anitha
724 views

1 answer to this question.

0 votes
Hi anitha,

Follow below steps:

1. Split the order field and create a new field using calculated field.

Store-id = SPLIT([Order Id],'-',3) and code = SPLIT([Order Id],'-',2)

2. Now put the order id in text shelf, created field in the filter shelf or parameter and show the details of those orders.

Hope this helps you.
answered Apr 10, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
15,296 views
0 votes
1 answer

Filtering in Tableau by combining multiple fields

Try This Create 3 parameter Start Date End Date City Now Create a ...READ MORE

answered Aug 30, 2018 in Tableau by Atul
• 10,240 points
854 views
0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by ffdfd
• 5,550 points
1,198 views
0 votes
1 answer
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
9,832 views
+2 votes
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
1,561 views
+2 votes
1 answer
0 votes
1 answer

Multiple column - multiple actions in same worksheet

Hi Sindhu, Create a action for every column ...READ MORE

answered Apr 5, 2019 in Tableau by Cherukuri
• 33,030 points
1,462 views
0 votes
2 answers

How can I add text in the centre of a Donut Chart ?

Hi, You can read this for creating a donut ...READ MORE

answered Apr 4, 2019 in Tableau by Cherukuri
• 33,030 points
12,054 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP