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
25 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
• 17,870 points

Related Questions In Tableau

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
45 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
72 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
991 views
0 votes
1 answer

Replacing Data Source from one Server to Another

I did something similar to it For ...READ MORE

answered Sep 19, 2018 in Tableau by Naruto
• 710 points
35 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,367 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
50 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
• 17,870 points
14 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
• 17,870 points
36 views