Show data from 2 different sheets in one sheet

Question

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.

Answer 1

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.