5 Replies Latest reply on Jun 15, 2016 6:34 AM by Mark Fraser

    Level of Detail Question from a Beginner

    Peter Lakie

      Looking for help from an experienced user:

       

      I sell parts to customers who have platforms, each platform has a certain number of units and my sales are different for each platform.

       

      I want to find the average sales for each platform.  In words this would be the total sales divided by the number of units for that platform.

       

      Every time I try to do this in Tableau I get a much lower result as I am dividing by the number of units for each time the same platform is listed rather than just one value of the units.

       

      I have made a simple file to illustrate.

       

      I am sure this is a LoD issue but I have tried INCLUDE / EXCLUDE but still can't get to the right answer

       

      Any help greatly appreciated!