4 Replies Latest reply on Mar 21, 2012 11:36 AM by Eric Berry

    Binning child companies based off of the size of parent companies

      Hello-

       

      I have a dataset that includes sales information to a number of child companies. Each child company falls under a parent company. In my dataset there are 1300 lines, each representing a different child company, all of which roll up to 100 parent company's, where the parent company is denoted in one of the fields in the data.

       

       

      I would like to bin my child companies based on parent company size and compare price bands for the same product. For instance, I would like to plot price paid (dimension) against something like this:

       

      if sum([Revenue]) > 1000 then "big customer"

      else "small customer"

      end

       

      I noticed when I created this calculated field and dragged it to the X axis, Tableau marked it as an aggregate calculation. How do I get it to aggregate based on parent company?

       

      Thank you!

       

      Geoff