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 in Tableau by Anitha
35 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 by Cherukuri
• 31,840 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 in Tableau by ch
• 3,290 points
17 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,550 points
68 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 19, 2018 in Tableau by Atul
• 5,530 points
354 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
1,873 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
2,208 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
99 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 in Tableau by Cherukuri
• 31,840 points
23 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 in Tableau by Cherukuri
• 31,840 points
82 views