7 Replies Latest reply on Feb 8, 2017 4:02 AM by Norbert Maijoor

    Append the aggregation calculation result to every single row

    Yangyi Zhang

      i want to append my aggregation calculation to every single row. but i'm not sure how to do the calculation.

       

      Example:

       

      Raw Data
      IDValue
      130
      130
      140
      2100
      2200
      2300

        

                       

      Tableau   Aggregation Calculation
      IDValueCalculate Field
      1100<500
      2600>500

       

                                                

      Expected Result
      IDValueCalculate Field
      130<500
      130<500
      140<500
      2100>500
      2200>500
      2300>500

       

       

      Is there any calculation can achieve this, i don't want to do it in excel anymore...

       

      Many Thanks !!