2 Replies Latest reply: Jul 11, 2014 7:57 AM by dick elsman RSS

    Splitting data into 3 groups

    dick elsman

      Hi guys,

       

      So I have a problem I can't seem to think my way around:

       

      i have a dataset of trucks with  certain profits, costs and margins.

      To analyse these trucks, i will need to split them up into 3 groups:

      - Best Trucks ( above  +10%  of average margin)

      - Average Trucks (between +10% and -10% of average margin)

      - Not so good Trucks. (below -10% of average margin)

       

      now i want to create a field that when i click on 'average', the set with margin between +10% and -10% is filtered (on the same way as when you select a specific month in the dataset).

       

      so I figured i would have to use avg(TOTAL Margin), but i don't know how to make a field using the statement..

       

      it would be awesome if you can help me!

       

      Best regards!

       

      Dick