Skip to main content

Hi All,

 

Is there any solution to get the totals of two different sheets in one for two different fields.

 

i have attached the superstore file along with this.

below is the screenshot for the same.

 

How to get the total from two different worksheets for two different fields

 

Regards & Thanks

2 réponses
  1. 8 avr. 2020, 10:30

    OK -

     

    your example is just using the sum of filtered from the same dimension - youi can get the total in a separate sheet by just canging the filter to include both Furniture and Technology

    But I am not certain that is the real question  are you really trying to total the values of different measures in a single sheet? if so you can just write a formula as Sum(measure1) + sum(measure2)

     

    You may not haave seen the announcement - Tableau is making their eLearning series available FREE for 90 days   see  eLearning: Tableau Web-Based Training

     

    I have tanke the courses and they are excellent

     

    JIm

0/9000