Show data from 2 different sheets in one sheet

0 votes
Hi, I want to show a bar chart from 2 fields used in 2 sheets in one sheet. How to do this? . I wan to use the products that i listed out in sheet1 using parameter to be shown in sheet2 to show profit and sales for those region.
Apr 25, 2019 in Tableau by Anitha
647 views

1 answer to this question.

0 votes
Hi Anitha,

Follow the below steps:
1. Create both sheets as per your question.
2. Create a calculative field to store the field value from the sheet using parameter selection.
  ( The list of items selected in 1 sheet make a group or make it as a field )
3. Now use the same field that you created in 1st sheet in sheet2 and drop profit field to display the profit and sales of products per region.

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

Related Questions In Tableau

0 votes
0 answers

show 2 charts with different data

Hi All, My requirement is to show 2 ...READ MORE

Oct 21, 2019 in Tableau by ch
• 3,450 points
489 views
0 votes
1 answer

Not able to publish workbook in Tableau Server after upgrading it from Tableau 9.1 to 9.2

Following is a little hack that will ...READ MORE

answered Jun 19, 2018 in Tableau by xyz
• 1,560 points
1,113 views
+1 vote
1 answer

How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

answered Jul 20, 2018 in Tableau by ffdfd
• 5,550 points
10,849 views
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,312 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
9,851 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,569 views
+2 votes
1 answer
0 votes
1 answer

Blend two different fields from 2 tables into one field.

Hi, Follow below steps: 1. Connect to both data ...READ MORE

answered Apr 3, 2019 in Tableau by Cherukuri
• 33,030 points
811 views
0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
• 33,030 points
3,560 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