8 Replies Latest reply on Feb 3, 2014 2:13 AM by . Indumon

    How to calculate Average/Sum of de-selected data source?

    Math Hunter

      I have a data source of 80 companies. For each company there are a lot of operating figures for each year: profit, costs, sales, employees …

      In tableau you can choose the companies and years by multiple values for every figure. This will list in a simple table or chart (rows=companies, columns=years, and operating figures = measures).

       

      Now, I would like to show the average or sum of a operating figure for the complete data source, not only the chosen companies in tableau. So you would be able to see the average of a operating figure for the whole industry (each year) even though you only chose two or three companies.

       

       

      How can I get this?