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 in Tableau by anitha
8 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 by Cherukuri
• 17,630 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
939 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 29, 2018 in Tableau by Atul
• 10,240 points
42 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 Atul
• 5,530 points
31 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
102 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,309 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
48 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 in Tableau by Cherukuri
• 17,630 points
33 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 in Tableau by Cherukuri
• 17,630 points
410 views